Forum Discussion
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?
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
6 Replies
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
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
