Forum Discussion
RAHEEL
Helper I
Helper IChange excel datasource to Web/sharepoint file
Dear All, I have a powerBI file with source set to local excel sheet placed on my c drive. Now I have the same excel sheet place on the sharepoint and I want to use that sharepoint file as a source....
v-caliao-msft
Microsoft Employee
Microsoft Employee
Create a new report in Power BI desktop to create a connection to excel file from Sharepoint site, please refer to the link below to see the details.
https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/
Then go to Query Editor->Advanced Editor. copy the Source and paste it in your original report source.
Regards,
Charlie Liao