A common task when cleaning data is to perform multiple replacements at once. When dealing with “translation tables” you might have come across Chris Webb’s solution using List.Generate to deal with this. (…) Read more
Posts in Category ‘Power BI’
Universal JSON-opener for Quandl in PowerBI and Excel/Power Query
Today I discovered JSON (…confess) and Quandl. Mates – this is powerful! Here comes just a quick function to automatically expand all columns of a time-series at once:
How to hack yourself in Power BI (and Power Pivot?)
Reading Gerhard Brueckl’s post on how to visualize SSAS calculation dependencies reminded me of my post about a similar technique from December last year. His solution has features that would do (…) Read more
PowerBI Best Practice: Views for non-database data
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
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