Editing connection string in Power BI report server.

[Anonymous]

Hello All, 

How to edit the power BI connection string in Power BI report server? we're in the process of publishing numerous PBI reports from test PBIRS to uat PBIRS. Rather than manually changing the datasources in each report and publish it to a different env.

Is there a method to deploy the Power BI reports to multiple environment with different connection strings or to programmatically edit the connection string?

Thanks in Advance.

[vk_pbi]

You can use Powershell or REST Api method to achieve this task. I have used New-RsDataSource method to replace the datasource connection string programatically using powershell. 

New-RsDataSource -RsFolder "/Datasources" -Name "Xyz" -Extension "Oracle" -CredentialRetrieval Store -ConnectionString $ConnString -DatasourceCredentials "Username" -Overwrite