If you use Power Query or the query editor in Power BI every step you take will be recorded and translated to M-code. You can share this code and it (…) Read more
Posts in Category ‘Power Query’
Select rows that have no empty fields using Expression.Evaluate in Power BI and Power Query
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
How to use regular charts on dynamic pivot tables in Excel
There are many good reasons not to use Pivot charts as described in this article i.e. – one I would like to add is the bug when using “invert if negative”: (…) Read more
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