Edit 03 Aug 2016: With the July 2016 release you can now run your R-scripts directly in the query-editor (so no row-limit any more!). No need to go via the (…) Read more
Posts in Category ‘little Tipps&Tricks’
Visualize dependencies between your DAX measures: DAX-VizArt-Wizard
This DAX-VizArt-Wizard vizualizes dependencies between your DAX measures, shows the definition of all related measures and shows differences between the measures of 2 models/versions. This works for Power Pivot, Power BI (…) Read more
Tip for Parameter Tables in Power Query and Power BI
Parameter tables in Excel are normally set up like this: In order to retrieve the currency for example, you could write this: = Parameters[Value]{2} This returns the content of the “Value”-column of (…) Read more
How to auto-parametrize your Power Query queries
This is about a technique that I’m going to use in my upcoming articles on ICT reconciliation. But as it is useful in other areas as well, it’s getting its own post (…) Read more
Filter SQL-server queries with Excel-tables: Query folding limitations and bug workaround
Power Query provides excellent functions to filter your SQL-Server queries by complete Excel-tables instead of just single parameters (like in all other Excel-based approaches). But you need to take care that (…) Read more
Power Query Management Studio reloaded: Now supports MDX
Very happy to see that my Power Query Management Studio isn’t just perceived nerdy but useful as well 🙂 Thanks to Dusty for his nice review. So let’s push it a bit further (…) Read more