Forum Discussion
Solved
Change 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.
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.
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