This article describes the use of Expression.Evaluate as a very helpful “swiss-army-knife”-method for your Power BI toolbox as it has many more use cases than the one described below. It (…) Read more
Posts in Category ‘Power BI’
How to create a Load History or Load Log in Power Query or Power BI
If you want to collect your regularly loaded data without overwriting it or create a load log that writes the load activites with a timestamp into a table, you need to (…) Read more
Trap in Replacement function in Power Query/M/PowerBI
Recently Power Query’s replacement function greeted me with some unexpected results: I applied the same steps but sometimes replacements of blanks with nothing did what it should and sometimes not. What (…) Read more
Visualize query dependencies in Power BI with Sankey diagram
Edit 7th August 2016: You’ll find an easier “OneInAll”-approach in the PowerBI forum here. Thanks to David Moss for reporting an issue with the solution below. PBI-file with new query: (…) Read more
Use R to export data from Power BI
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
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