All posts reflect my own thoughts and not those of any employer or organization.
Analytics Professional dabbling in MDM and Power BI
He/Him
All posts reflect my own thoughts and not those of any employer or organization.
Analytics Professional dabbling in MDM and Power BI
He/Him
The perfect scientific paper for @SQLAllFather doesn't exist....
Oh wait...
https://www.vox.com/2014/11/21/7259207/scientific-paper-scam
π€£
In this video, I take a deep dive into optimizing #powerquery folding in #powerbi with Reid.
Query folding is often referred to as if it is a performance panacea. In fact, query folding just means that M is compiled to a semantically equivalent expression in the data source.
How do we understand the relative performance of multiple different folded queries that yield the same result?
As cool as #PowerBI is, almost every company has use cases where a #PaginatedReport is the right solution. For the last decade or so, paginated reports have done the basic well but haven't been able to do much more. The introduction of PQ is opening up some great scenarios and I love that @chrisw3bb is highlighting these on his blog.
Here is the latest on how you can use PQ and APIs to insert an Azure Map into a report!π€―
https://blog.crossjoin.co.uk/2024/04/07/displaying-azure-maps-in-a-power-bi-paginated-report/