How to Import JSON files from OneDrive folder? (folder updates continously with more .json files)

[ErancO]

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-D... 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!

[v-jingzhang]

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.aspx

You 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_com

You can also try SharePoint.Contents function. Here are two articles for your reference:

SharePoint and OneDrive for Business files import - Power Query | Microsoft Learn

Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed - RADA...

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.