Forum Discussion
Get multiple json files from Onedrive folder into powerbi
Hello All, In my Onedrive i am having more than 1000 json files and i would like to load those json files into powerbi and create a report. I have tried with a single json file in below images. ...
Hi Anonymous,
You should first add a custom column with the custom formula
Json.Document([Content])
Then, depend on which Json file you want to query, click the corresponding cell under the new custom column. The subscequent steps are the same as that applied to loading single json file.
Best regards,
Yuliana Gu
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
You should first add a custom column with the custom formula
Json.Document([Content])
Then, depend on which Json file you want to query, click the corresponding cell under the new custom column. The subscequent steps are the same as that applied to loading single json file.
Best regards,
Yuliana Gu