topic Re: Update data source password using Powershell without prompting user to input password in Report Server

Update data source password using Powershell without prompting user to input password

vk_pbi — Wed, 20 Sep 2023 06:00:08 GMT

I have used Powershell to create a datasource in Power BI Report server. The code works fine, but only thing is, it prompts user to input password. I want to pass this value programatically to avoid manual input. Is there a way to update the password programatically. I have used below code to create a datasource

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

Re: Update data source password using Powershell without prompting user to input password

AnthonyGenovese — Wed, 20 Sep 2023 22:18:07 GMT

It looks like you can add a password, I would follow the example set out here.

https://github.com/Microsoft/ReportingServicesTools/blob/master/Tests/CatalogItems/New-RsDataSource.Tests.ps1

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

Re: Update data source password using Powershell without prompting user to input password

vk_pbi — Fri, 29 Sep 2023 07:16:38 GMT

Thanks.. now the problem fixed.. I need to a create a function to handle the username and password, Powershell script, doesn't have that supported parameter