Forum Discussion
How to Import JSON files from OneDrive folder? (folder updates continously with more .json files)
Hello!
I'm currently using "folder" option to get and combine multiple .json files from my PC locally (the folder is in OneDrive), but I need to automate this through the web. I tried using SharePoint folder but it doesn't work.
I was checking this https://community.powerbi.com/t5/Community-Blog/Import-JSON-files-from-multiple-URLs-into-Power-BI-Desktop-and/ba-p/1615660 but my issue is that the folder gets more .json files continously, so I can't put all the URLs every time the dashboard is updated/published.
Please help,
Thank you!
1 Reply
Hi ErancO
The SharePoint folder connector and its experience also work for files hosted on OneDrive for Business. However, the URL that you need to use is different from the one you would use for a SharePoint site. To locate your unique URL, go to your OneDrive for Business portal and copy the URL from your browser. This URL may look similar to the following example:
https://contoso-my.sharepoint.com/personal/user123_contoso_com/_layouts/15/onedrive.aspxYou don't need the full URL, but only the first few parts. The URL you need to use in Power Query will have the following format:
https://<unique_tenant_name>.sharepoint.com/personal/<user_identifier>For example:
https://contoso-my.sharepoint/personal/user123_contoso_comYou can also try SharePoint.Contents function. Here are two articles for your reference:
SharePoint and OneDrive for Business files import - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
