Forum Discussion
Source file Error
Hello, I have been using an excel file as my data source and the file is on SharePoint, so that multiple users can access the data and make changes. I have stored the PowerBI file on SharePoint ...
Hi - It would appear that the filepath is mapped to a local machine and not a sharepoint filepath.. You can get the sharepoint filepath by right-clicking on Open File Location and copying the filepath. Replace everything up to \filepath name and update the source in your BI report. This should work for you provided all your colleagues have access to the sharepoint
file.
The link below might help.
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
Hopefully this helps.
D