Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
vk_pbi
Resolver II
Resolver II

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

 

 

1 ACCEPTED SOLUTION
AnthonyGenovese
Resolver III
Resolver III

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!

View solution in original post

2 REPLIES 2
AnthonyGenovese
Resolver III
Resolver III

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!

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

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.