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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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