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

[vk_pbi]

Hi 

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

[AnthonyGenovese · Accepted solution]

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....

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!

[vk_pbi]

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