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