topic Re: Datasources bulk password update in Report Server

Datasources bulk password update

Anonymous — Tue, 13 Oct 2020 16:54:53 GMT

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?

Re: Datasources bulk password update

sevenhills — Tue, 13 Oct 2020 18:22:02 GMT

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/CatalogItems/Set-RsDataSourcePassword.ps1

----

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

Thanks

Re: Datasources bulk password update

Icey — Wed, 21 Oct 2020 05:58:42 GMT

Hi Anonymous ,

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.

Re: Datasources bulk password update

Icey — Thu, 29 Oct 2020 03:45:09 GMT

Hi Anonymous ,

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