Currently, we cannot connect to Power BI dataflows from Excel Power Query. And as we also cannot use custom connectors in there, we need a different alternative. I’m going to (…) Read more
12 Search Results for ‘json’
Compare Power BI files with Power BI Comparer tool
Have you ever wanted to compare a version of a Power BI file with a previous one? … In the unlikely case that you haven’t yet, just wait until the (…) Read more
Easy way to retrieve Teams data in Power BI via Flow (and other data from the Graph)
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
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
How to expand a column that cannot be expanded in Power BI and Power Query in Excel
Especially when working with JSON-data, you might end up with a column that has elements of mixed types in it. The expand column – arrows will be missing, but some elements still need (…) Read more