cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RAHEEL
Helper I
Helper I

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

 

1 REPLY 1
v-caliao-msft
Microsoft
Microsoft

@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.
Capture.JPG

 

Regards,

Charlie Liao

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!