Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I would like to use the following JSON from data.gov:
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!
Solved! Go to Solution.
Hi @MTam,
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
Hi @MTam,
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
Hi @MTam,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |