cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RAHEEL Regular Visitor
Regular Visitor

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
Moderator v-caliao-msft
Moderator

Re: Change excel datasource to Web/sharepoint file

@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
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 71 members 1,192 guests
Please welcome our newest community members: