Forum Discussion
Using web as a datasource to JSON data but instead asking to open or save as a JSON source file
Hi all, I have a url which links to JSON data like below. But when I enter this address in the web data source in POwer BI to connect to the JSON data, I get the below screen instead askin...
Hi pjose
That pop-up window indcates that the URL is sending a file with the extension .json, that's not the same as sending raw JSON data.
Try opening the URL with Web.Contents or Web.BrowserContents and then process the result.
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.