Datasources bulk password update

[sanjay009]

I have 30 reports and they have 40 datasources most use same username and password. my password change every 2 months. my issue is after password change i have to manually update the password for all 40 datasources. Do we have solution with bulk password update?

[Icey]

Hi @sanjay009 ,

Please let us know if the replies above are helpful.

If they are, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let us know.

Best Regards,

Icey

[Icey]

Hi @sanjay009 ,

Please check if these documents could help:

Configure credentials programmatically for Power BI;

Set data source credentials on Power BI Report Server through REST API to create a scheduled refresh.

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[sevenhills]

Have a taken look at "ReportingServicesTools" > "Set-RsDataSourcePassword". If not my advise is to take a look at it.

Example is also provided in the comments

https://github.com/microsoft/ReportingServicesTools/blob/master/ReportingServicesTools/Functions/Cat...

----

By the way, I will say to use shared datasource, which will lessen your maintenance in long term.

Thanks