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 ‘M’
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
Custom Connector to import Google Sheets with OAuth2 authentication in PowerBI
EDIT 17th Feb 2022: Finally, we have the native connector in Power BI: Power Query Google Sheets connector – Power Query | Microsoft Docs – so no need for the (…) 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