Marco Russo has shared bunch of very valuable PowerBI best practice tricks for designing your PowerBI model here: http://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/?platform=hootsuite One of them being never to directly import a database table, but (…) Read more
Posts Tagged ‘Power Query’
How to share M-code in PowerBI and Power Query
One of M’s advantages is that you can share M-code in textform and it will run instantly on a different computer. So no need to actually exchange a file. Provided that (…) Read more
How to handle M-code samples
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
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