Editing connection string in Power BI report server.

Anonymous — Tue, 19 Sep 2023 21:49:11 GMT

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.

Re: Editing connection string in Power BI report server.

vk_pbi — Wed, 20 Sep 2023 06:07:39 GMT

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

topic Editing connection string in Power BI report server. in Report Server

Editing connection string in Power BI report server.

Re: Editing connection string in Power BI report server.