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

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 - RADACAD

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