Change source from local path to OneDrive for the complete folder

[Anonymous]

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? 

[Anonymous · Accepted solution]

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

[lukiz84]

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