Datasource change environment

[raulcruzv]

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?

[_sfrost]

@raulcruzv 

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!

[Anonymous]

You can go to Query and "Advanced Editor" and change it manually.

[GilbertQ]

Hi @raulcruzv

When you mention "Is it really necesary to do that modification in a new PIB desktop file", what do you mean?

Is it for a link for users, or Dashboard tiles linking to the report?

[raulcruzv]

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)

[v-sihou-msft]

@raulcruzv

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,