Forum Discussion
Update data source password using Powershell without prompting user to input password
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
It looks like you can add a password, I would follow the example set out here.
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!
2 Replies
It looks like you can add a password, I would follow the example set out here.
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!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
