Some time ago I wrote a blogpost on how to create a function library in Power BI or Power Query (http://www.thebiccountant.com/2017/08/27/how-to-create-and-use-r-function-library-in-power-bi/). There I also presented a way to pull that (…) Read more
Posts in Category ‘M’
Permutations table in Power BI or Power Query in Excel
Today my husband came with a special task to me: He had to re-wire an old instrument on board of our sailing boat and “lost” the original matching instructions. There (…) Read more
Migrate a Power Query or Power BI file to a local SSAS instance
Edit: This feature has been deprecated since 1st March 2019 unfortunately: https://azure.microsoft.com/en-us/updates/azure-analysis-services-web-designer-to-be-discontinued/ – Microsoft is working on replacement of the functionality to move pbix-files to SSAS-instances, but no solution yet. In (…) Read more
Web Scraping 2: Scrape multiple pages at once and refresh in Power BI service
In the first post of this series I’ve explained how to simultaneously load and combine multiple (similar structured) tables from ONE PAGE. This post handles the other direction, how to combine tables (…) Read more
A generic SWITCH-function for the query editor in Power BI and Power Query
Although you can easily replicate the DAX SWITCH-function via list-, table- or record functions in M, I thought it would be convenient for many newbies to have a comfortable M-SWITCH-function that (…) Read more
Web Scraping 1: Combine multiple tables from one page in Power BI and Power Query
This is a step-by-step description of how to combine multiple tables from one webpage into one table with categories as output. You can also apply this technique to combine tables from (…) Read more