Create Gateway Connection - API

Hi pvuppala 

While PowerShell provides flexibility and encryption support, many teams are indeed exploring more scalable and automated solutions like Power Automate or Azure Automation to remove dependency on individual desktops.

As of now, Power Automate doesn’t natively support direct creation of gateway connections through built-in connectors, but you can integrate it with custom connectors or Azure Functions that call the Power BI REST API (like the createDatasource endpoint you referenced).

By doing so, you can fully automate the process using cloud-native tools and potentially trigger actions based on events (like password rotation alerts from CyberArk).

Long-term, combining Azure Key Vault for secrets management and an automation engine like Azure DevOps or Logic Apps could give you even more control and traceability, especially if you're aiming for CI/CD practices around Power BI deployments.

It’s promising to see more organizations moving in this direction, and Microsoft’s growing API surface will hopefully support these use cases more natively in the future.