Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
I have the same problem with you, if you success to change the source please tell me. thankyou
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