Edit: Unfortunately this method isn’t working any more for files with the latest Power BI file formats (including the enhanced metadata format). If you want to audit or analyse the (…) Read more
Posts in Category ‘Power Query’
Create a function library in Power BI using M-Extensions
Having the ability to use own M-function the same way than native functions in Power BI and Excel has been one of my biggest wishes for quite some time. So I (…) Read more
Number.Mod rescue pack for Power BI and Power Query
If you use the M-function Number.Mod in Power BI or Power Query and expect the same result like in Excel or DAX, you are probably in good company. But if (…) Read more
How Power Query can return clickable hyperlinks with friendly names to Excel
When you use Power Query as an Excel-automation-tool rather than just to feed the data model, you might want to return clickable hyperlinks that carry friendly names. This doesn’t work out of (…) Read more
How to open a complex JSON record in Power BI and Power Query
Today I’ll show you a very useful technique how to deal with a JSON record that contains a wild mixture of different elements like this: If you click on one (…) Read more
How to create and use an R-function-library in Power BI
Edit 10-10-2017: There is also a (simpler) way to run a custom function library described here: http://www.thebiccountant.com/2017/10/06/create-a-function-library-in-power-bi-using-m-extensions/ . If you go that route, the only point of interest in the (…) Read more