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 changi...
"Power BI Report Server"
vk_pbi's avatar
vk_pbi
Icon for Resolver II rankResolver 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