Forum Discussion
Change source from local path to OneDrive for the complete folder
I would like to share my dashboards with my colleagues, but since my Excel files are stored locally, they cannot transform data.
I use the following as a source:
= Folder.Files("C:\Users\my_name\my_company\folder")
All my excel files are stored in this folder but those same Excel files are also together in a folder on a shared OneDrive. Is there a quick solution to be able to change this for all Excel files?
In stead of Folder.Files, use SharePoint.Files("https://x-my.sharepoint.com/personal/your_name", [ApiVersion = 15])
! Important, you can only use the root folder to make a connection
2 Replies
lukiz84Memorable Member
The onedrive folder is also different on every computer... if not, just replace the local path with the onedrive path.
Better: Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Learn
In stead of Folder.Files, use SharePoint.Files("https://x-my.sharepoint.com/personal/your_name", [ApiVersion = 15])
! Important, you can only use the root folder to make a connection