Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Editing connection string in Power BI report server.

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.

"Power BI Report Server"

1 Reply

  • vk_pbi's avatar
    vk_pbi
    Resolver II
    2 years ago

    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