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
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
Automatically validate E-mail attachments with Flow and Power BI
Receiving files from business partners that don’t match the agreed requirements/formats causes all sorts of problems in daily business. I found it particularly disturbing during month-end closing when time is (…) 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