Change excel datasource to Web/sharepoint file

[RAHEEL]

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

[Anonymous]

I have the same problem with you, if you success to change the source please tell me. thankyou

[v-caliao-msft]

@RAHEEL,

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