Forum Discussion
gp10
Advocate III
Advocate IIIGateway Connection Rotating Credentials
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....
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
Here is a good article using powershell - Automated updation of Power BI Data Source Credentials (data4v.com)
gp10Advocate III
Advocate IIIThanks Anonymous , but that is on the dataset level. I want to update the credentials to the gateway connection.