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
12 Search Results for ‘json’
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 store tables longer than 1,1 Mio rows in an Excel-sheet using Power Query and JSON
If you are working Power Query, you might come into a situation where you would like to make tables accessible from outside that file, that are longer than the 1,1 Mio rows (…) 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:
Using System Assigned Managed Identity for API imports into Azure SQL databases
For Azure SQL Databases there is a very cool new preview feature: “sp_invoke_external_rest_endpoint “. This function allows you to call certain Microsoft API endpoints directly from within your Azure database (…) Read more