The function Json.FromValue provides a super-easy way to create POST-calls to web services that require JSON format in their body parameters. Background If you want to make a POST request (…) Read more
Posts Tagged ‘M’
Import data from multiple SharePoint lists at once in Power BI and Power Query
This is a quick walkthrough on how you can easily import multiple SharePoint lists at once, just like the import from folder method. Start as usual You start your import (…) Read more
Automatically create function record for Expression.Evaluate in Power BI and Power Query
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
RegEx in Power BI and Power Query in Excel with Java Script
From time to time Huang Caiguang sends me some geeky M-code that turns out to be very useful (like this for example). Today it’s utilizing java script code for RegEx (…) 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