Forum Discussion
AllanXu
Helper II
Helper IICan I have a JSON file as data source
Greetings,
is it possible to have a JSON file (local or in Azure BLOB) as a datasource?
Thank you,
Yes - use Get Data / From Web and enter the URL (or local path) to the JSON file. PBI will interpret that file as JSON and show you the root node, which you can drill in and expand on to get to the data elements you want.
The exact steps will depend on the shape of your JSON.
I described this process using a publicly-available JSON file and Excel Power Query (the predecessor of the PBI Get Data UI):
