SQLAllFather on Nostr: So far I have used a notebook to load into my bronze lake all of the tables I'll ...
So far I have used a notebook to load into my bronze lake all of the tables I'll need, and I'm using the SQL endpoint (❤️ ) to build a view that will return the area_id for every area, and the area_id for its ultimate parent as country_id.
This is where I gave up trying to implement this solution using #PowerBI alone. Although I probably could have built this view as a #PowerQuery, there were too many variables working against me. The source data is located in multiple text files, the schema is belligerently opaque and obtuse, and for a pet project there's only so much nonsense I can put up with at any one time.
With Fabric, I have the right tools for the job, and instead of fighting with Power Query performance when merging large text sources to themselves over and over, I can focus on the data itself.
2/
This is where I gave up trying to implement this solution using #PowerBI alone. Although I probably could have built this view as a #PowerQuery, there were too many variables working against me. The source data is located in multiple text files, the schema is belligerently opaque and obtuse, and for a pet project there's only so much nonsense I can put up with at any one time.
With Fabric, I have the right tools for the job, and instead of fighting with Power Query performance when merging large text sources to themselves over and over, I can focus on the data itself.
2/