Forum Discussion
Create a dynamic value for Json.Document function
Hi All, I'm using the function Json.Document to get data from an API. Below is the an example of the Json.Document value: Json.Document(Web.Contents("https://url.com/site/222222/energyDetail...
Welcome to the wonderful world of the formula firewall. Happy reading.
Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Docs
Inline your queries if possible.
read about the Query option for Web.Contents()