Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |