topic Re: Updating Connection Credentials in Service

Updating Connection Credentials

Anonymous — Thu, 11 Mar 2021 08:15:46 GMT

Hello Guys,

The database passwords within my organizations are set to expire every 30 days and would need to be changed. I have alot of reports published to different workspaces and i usually go and update the new passwords all of the reports one by one even though most of them are connecting to the same database.

I would like to find out if there is a way i can just update the crendentials for all the reports at once?

Re: Updating Connection Credentials

nandukrishnavs — Thu, 11 Mar 2021 10:27:11 GMT

Anonymous

Try to configure the On-premises data gateway and add the data source credentials to a particular cluster. So, you can reuse the same connection across multiple reports.

Regards,
Nandu Krishna

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍

Proud to be a Super User!

Re: Updating Connection Credentials

v-robertq-msft — Fri, 19 Mar 2021 09:32:43 GMT

Hi, Anonymous

Do your datasets need a gateway to be refreshed?

According to your description, you said you have to update the new passwords for all of the reports one by one. But I don’t think you have to do so, because you can just configure one data source in the gateway and map it to each dataset that connects to this data source.

If your datasource is in the cloud and don’t need gateway, you can just try to use one dataset to create multiple reports. This method can also help you to update as less crendentials as you can when the password is changed.

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.