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
Posts in Category ‘Power Query’
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
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