Forum Discussion
Datasource change environment
In order to redirect a report wich was deployed into Power BI Online from QA to PROD environment, Is it really necesary to do that modification in a new PIB desktop file? Isn't it possible to do that from the service itself?
5 Replies
What I'd like to do is having an option where we are able to modify the datasource without the need of publishing the *.pbix file again.
With "datasource" I mean having the possibility to change from ServerA to ServerB (e.g. SQL Server QA to SQL Server PROD)
It's not supported to edit the data source on Power BI Service. If you want to change the server name of data source, you have to edit in .pbix file or create a new one and publish again.
Regards,
AFAIK, you can achieve this with the following REST API. However, it supports only limited number of sources and it has few restrictions. For more info, I would suggest you to refer to the below doc:
Datasets - Update Datasources In Group (Power BI Power BI REST APIs) | Microsoft Docs
Did I answer your questions? Give a thumbs up and accept this post as solution!
