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
All Posts by Admin
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
Easy unstacking of columns in Power BI and Power Query (and Excel)
The demand to unstacking a column into a table is not rare (see here for example: PowerBIForum ) . Also if you copy a table from a post in the (…) 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