Change Sharepoint datasource

[Anonymous]

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?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

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

[Anonymous]

Hi @v-yulgu-msft

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

[GilbertQ]

Hi @Anonymous

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

[Anonymous]

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...

[GilbertQ]

Hi @Anonymous

Apoligies for missing that.

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

[Anonymous]

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