Convert JSON data from data.gov

[Anonymous]

Hi All,

I would like to use the following JSON from data.gov: 

This file

But I am not able to find the right way to convert it to table. Can you give me some instruction for the solution of this issue. CSV and XML work well.

By the way is there any fix logic to convert this type of files?

Thanks for your help!

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

You could use the 'Convert into table' function in query editor after you have imported your json file. You could also refer to below link:

https://community.powerbi.com/t5/Integrations-with-Files-and/An-json-example/td-p/57447

Regards,

Daniel He