In a previous post I’ve described how to use a custom connector to retrieve data from the Microsoft Graph API. But this requires to register an App and adjusting the (…) Read more
Posts in Category ‘M’
Query folding on JoinKind.Inner gotcha for Power BI and Power Query
If you query databases who support query folding, you’re probably very aware of every step you take and check if folding happens with every new step like so: Folding will (…) Read more
How to get more out of your Graph API custom connector in Power BI
Edit: Microsoft has announced that they don’t support querying MS Graph in Power BI: Lack of Support for Microsoft Graph in Power Query – Power Query | Microsoft Learn The (…) Read more
Bulk-extract Power Query M-code from multiple Excel files at once
Some time ago I published a function that extracts all M-code from Power BI (.pbix)-files. Today I publish the pendant to Bulk-extract Power Query M-code from multiple Excel-files at once. (…) Read more
Types in PowerQuery cannot be compared and a Type.AsText function
Sometimes I need to retrieve the textual representation of a type in Power Query and I’m using a fairly verbose function that I’ve stolen ages ago (I believe it was (…) Read more
Screenshot tutorial: Add a column with custom function code in Power Query
The following steps show how to create a new column in a table using existing custom function code. This works in Power BI as well as in Power Query in (…) Read more