Edit 5th May 2019: Unfortunately this method will not work in the Power BI service! In my last 2 posts I’ve described a way to automatically validate attachments from incoming (…) Read more
Posts Tagged ‘JSON’
Automatically expand all fields from a JSON document in Power BI and Power Query
If you work with JSON documents that are new to you, it can be very helpful to fully expand JSON to see at a glance what’s in there. The following (…) 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
How to open a complex JSON record in Power BI and Power Query
Today I’ll show you a very useful technique how to deal with a JSON record that contains a wild mixture of different elements like this: If you click on one (…) Read more
How to expand a column that cannot be expanded in Power BI and Power Query in Excel
Especially when working with JSON-data, you might end up with a column that has elements of mixed types in it. The expand column – arrows will be missing, but some elements still need (…) Read more
Universal JSON-opener for Quandl in PowerBI and Excel/Power Query
Today I discovered JSON (…confess) and Quandl. Mates – this is powerful! Here comes just a quick function to automatically expand all columns of a time-series at once: