Forum Discussion
Desktop - share onedrive datasource
Hi,
My power bi model (power bi pro) model consists of mainly .csv files (and some Excel files) located on the organisations onedrive folder. We are several people working on the same pbix file. The problem is however when I view the data source settings, under "Data source in current file", the listed files typically are referred to as something like: "c:\users\localuser\onedrivefolder\filename.csv". This is a shared onedrive folder, but it is treated by PBI like a local folder ("c:\users"). Therefore when another user tries to refresh the data in the pbix file in desktop, they get an error message saying the files can not be found, and they need to change source for every file in the model. This needs to be done every time another user wants to edit the pbix file and refresh the data.
My guess is that there is a way to refer to the onedrive folder as a network folder, but I don't see onedrive as a datasource in the desktop version. Is there any way to resolve this issue ?
You can connect one drive files through sharepoint or directly through web url
https://www.c-sharpcorner.com/article/connect-to-onedrive-excel-file-from-power-bi-desktop/
2 Replies
- mh2587Super User
You can connect one drive files through sharepoint or directly through web url
https://www.c-sharpcorner.com/article/connect-to-onedrive-excel-file-from-power-bi-desktop/ - nextanNew Member
Worked like a charm, thank you so much!