Updating Connection Credentials

Question

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?

v-robertq-msft · Accepted Answer

Hi, Anonymous&nbsp;
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.

&nbsp;
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.
&nbsp;
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.

Forum Discussion

Updating Connection Credentials

2 Replies

Related content

Unable to update connection credentials. Invalid connection credentials.

Invalid Connection Credentials

Unable to update connection credentials. Invalid connection credentials.

Update connection , dataset credentials Using Rest API

Invalid Credentials - Snowflake Connection