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
Posts in Category ‘M’
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
Improved Text.SplitAny – function for Power BI and Power Query
Today I’ll present an adjustment to the Text.SplitAny – function in Power BI’s query editor or Power Query. The native function takes a string as an input and splits the (…) Read more
Create list of accounts from NAV account schedules or COA totaling syntax
In this blogpost I’ll show you how to create a list of account numbers from the totalling syntax that you find in Dynamics NAV account schedules or chart of accounts (…) Read more
Return all occurrences of text between delimiters in Power BI and Power Query
The M-function Text.BetweenDelimiters does what it says and returns the text between 2 delimiters in the query editor of Power BI and Power Query. But irrespective of its optional arguments (…) Read more