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
Posts Tagged ‘Power BI’
Export data from Power BI using Microsoft Flow
Edit 5th May 2019: Unfortunately this method will not work in the Power BI service! Edit 23rd August 2021: Pedro del Melo Cabral Sousa has found a workaround how to (…) Read more
Part 2: Automatically validate E-mail attachments with Flow and Power BI
In Part 1 of this little series I described the core-Flow on how to automatically validate E-mail attachments with Flow and Power BI. It automatically sends an e-mail to a (…) 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
Writing data to GitHub using Power Query only
You shouldn’t do it … Generally it’s a very bad idea to execute commands in Power Query that write out data to a source, as these commands might be executed (…) Read more