Forum Discussion
Change 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.
To change the data source from excel sheet to sharepoint I need assistance of experts. Could you please guide some of the steps to follow in order to successfully change the source from c drive excel sheet to sharepoint excelsheet. Thankyou
Regards,
Raheel Farooq
2 Replies
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
