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
Get full Time Activity data from QuickBooks into Power BI
Problem As per the time of writing, the native QuickBooks connector in Power BI has some shortcomings for the Time Activity-data: It will not return employee details (so you will (…) Read more
Export data from Power BI to csv using Python
In this blogpost I show you my M-Python-function that I use to export data from Power BI to csv files (Export Python). Why Python? I prefer it to R mostly (…) Read more