Forum Discussion
Change Data Source from Local Desktop to Sharepoint
- 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.
If this doesn't make sense I can write better instructions when I'm by the computer tomorrow.
This sounds simple enough. If the file names are different, will this automatically update the measures that reference the table?
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?
Hello Johanno,
Is it possible to get screenshots about you are suggesting as a solution? I was trying several times and I don't know what I'm doing wrong because I get many errors...
Thank you so much.
Ana M
Hi tried the same steps but I am getting stuck at the credentials. Have you come across this problem? I raised it here: Facing error when changing data source from excel ... - Microsoft Power BI Community
Sorry to wake up an old thread, but....
This worked so simply! It's a wonder that they haven't built in quick way to do this (without having to remember to delete a few characters in the filename). Thanks!!!
