Forum Discussion
Request POST with Json Body
Hi sonet141 ,
thererfore I'd recommend to use the function Json.FromValue instead:
Easy POST requests with Power BI and Power Query using Json.FromValue – The BIccountant
This means that you have to create the (nested) JSON-structure natively in Power Query and transform that using the function. This will convert booleans correctly, meaning keep them as a proper boolean in JSON.
Hi sonet141
you can build that nested structure in Power Query and then use the function Json.FromValue to transform it into the required JSON-format for the call.
About Json.FromValue: Easy POST requests with Power BI and Power Query using Json.FromValue – The BIccountant
Best article if you want to refresh in the service:
http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/