Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |