Forum Discussion
npowerbi
Advocate II
Advocate IIChange Data Source from Local Desktop to Sharepoint
Hi Experts, I have prepared a dashboard using a local excel file on my desktop. Now that I have completed my development, I need to connect to a similar file on Sharepoint. I am unable to fin...
- Well, you could just copy the file to Sharepoint. Open the Excel file on Sharepoint, upper left corner you can copy the path to the file. In Power BI you should be able to edit query and then change data source to the path you just copied. However! You need to delete the last characters (5 or so) in the path so that it ends with xlsx. Done.
If this doesn't make sense I can write better instructions when I'm by the computer tomorrow.
Johanno
Continued Contributor
Continued ContributorWell, you could just copy the file to Sharepoint. Open the Excel file on Sharepoint, upper left corner you can copy the path to the file. In Power BI you should be able to edit query and then change data source to the path you just copied. However! You need to delete the last characters (5 or so) in the path so that it ends with xlsx. Done.
If this doesn't make sense I can write better instructions when I'm by the computer tomorrow.
If this doesn't make sense I can write better instructions when I'm by the computer tomorrow.
Can you share a picture of what you're suggesting?
Do you mean this method: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Alternately, I have a PBIX query data source that points to a file that's stored on an enterprise one drive, but when I copy link to the file and edit the 'excel workbook' datasource in my pbix file it doesn't accept it. I think I have to change the whole data source from excel file to something else perhaps?