cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
daniel_webb Frequent Visitor
Frequent Visitor

Change Sharepoint datasource

Hi,

 

I have a report created in PowerBI Service based on an Excel file from Sharepoint Teamsite. The whole teamsite address has since been moved, is there anyway I can change the Excel file link?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yulgu-msft Super Contributor
Super Contributor

Re: Change Sharepoint datasource

Hi @daniel_webb,

 

As it is not available to view the data source path on Power BI servie, no matter whether the report is created on desktop or service, we are not allowed to edit the data source directly on service. You may need to re-create the report as suggested by guavaq.   You could check this idea Ability to change the data source connection string from PBI service and vote it up.

 

By the way, the only way to change the connection string from Power BI Service is using the API Set All Connections. This API only supports DirectQuery datasets.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 REPLIES 6
Super User
Super User

Re: Change Sharepoint datasource

Hi @daniel_webb

 

If you go into the Query Editor, and then click on your table that has the Excel file.

 

Then in the applied steps, the first step should be the Source. Click on the Gear Icon next to the Source, which should then bring up the location of the Excel File in SharePoint.

 

Now change this to your new location. And you should be good to go.

 

You can verify this once after changing the source if your table loads in the Query Editor. 

 

If it does click Close and Apply.

 

And you are good to go


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
daniel_webb Frequent Visitor
Frequent Visitor

Re: Change Sharepoint datasource

Hi @GilbertQ

 

As mentioned in the post, I created this report directly in PowerBI Service, not in Desktop, so do not have the query editor...

Super User
Super User

Re: Change Sharepoint datasource

Hi @daniel_webb


Apoligies for missing that.

 

I am not sure how to change it then. Besides re-creating the report from the start again.


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
daniel_webb Frequent Visitor
Frequent Visitor

Re: Change Sharepoint datasource

No problem @GilbertQ! That's what I'm afraid of, but thought I'd post here in case anyone else had gone through the same issue Smiley Happy

v-yulgu-msft Super Contributor
Super Contributor

Re: Change Sharepoint datasource

Hi @daniel_webb,

 

As it is not available to view the data source path on Power BI servie, no matter whether the report is created on desktop or service, we are not allowed to edit the data source directly on service. You may need to re-create the report as suggested by guavaq.   You could check this idea Ability to change the data source connection string from PBI service and vote it up.

 

By the way, the only way to change the connection string from Power BI Service is using the API Set All Connections. This API only supports DirectQuery datasets.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
daniel_webb Frequent Visitor
Frequent Visitor

Re: Change Sharepoint datasource

Hi @v-yulgu-msft

 

That's what I was expecting, thanks for the tip on the idea, I've added my vote!

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

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: 57 members 1,082 guests
Please welcome our newest community members: