Many Power Query function not only return their values as advertised in their function documentation, but on top of that a metadata record. This record is like tag that holds (…) Read more
Posts Tagged ‘Web’
Tips to download files from webpages in Power Query and Power BI
When downloading data from the web, it’s often best to grab the data from APIs that are designed for machine-to-machine communication than from the site that’s actually visible on the (…) Read more
Easy POST requests with Power BI and Power Query using Json.FromValue
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