It’s downing a bit slowly on me how awesome the direct retrieval of DMVs in PowerBI and PowerQuery actually is. Just see how easy we can build a cool view (…) Read more
Posts in Category ‘little Tipps&Tricks’
Pivot your table-relationships in Power BI and Power Pivot
While the relationships view of the datamodel provides a very good overview which tables are connected to each other, one cannot see at a glance on which field they are (…) Read more
Performance Tip: Partition your tables at crossjoins where possible – PowerQuery PowerBI
Recently I’ve distributed some techniques for partial matches or relative joins between tables using PowerQuery or the query editor in PowerBI. They are very flexible and powerful – yet slow. (…) Read more
How to edit M-function documentation metadata
After the great announcement yesterday that we will be able to ship custom functions within the shared environment, I’m expecting a lot of people starting to write awesome custom functions for M. Hopefully (…) Read more
Use Slicers for Query Parameters in PowerBI
Reading Rob Collie’s latest cool blogpost on how to retrieve slicer selections in Power BI, I couldn’t stop thinking of how awesome it would be, if we could use this (…) Read more
Blending data in PowerBI like in Tableau
Today I came across a question in the PowerBI-forum if blending data was possible in Power BI like in Tableau. Although I wouldn’t necessarily recommend it, it’s definitely is a nice (…) Read more