Forum Discussion
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 changi...
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