Gateway Connection Rotating Credentials

[gp10]

Hi community,

if we want to create a gateway connection to a Redshift db that has rotating credentials, do we have to update them manually every time or there is a way to automate this?

Thanks.

[3CloudThomas · Accepted solution]

here is the MS Learn page for powershell RESTAPI call, it has some options for encrypting the data passed but requires a lot of work

Gateways - Update Datasource - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[3CloudThomas]

Here is a good article using powershell - Automated updation of Power BI Data Source Credentials (data4v.com)

[gp10]

Thanks @3CloudThomas , but that is on the dataset level. I want to update the credentials to the gateway connection.