I have below use case:
Power BI running on azure which load data from RDS
The credentials to access RDS are configured at Power BI gateway dashboard(azure)
Now currently to change/rotate the password of RDS, we manually changing the password at RDS and update in the Power BI gateway
we are looking a solution to automate the password rotation using secret manager. so is there any possible approach to update GW password using secret manager lambda function?
Expected;
Once the secret manager are introduced, it should rotate the password and update in power BI gw.
