Forum Discussion
Helper VCreate 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.
Super UserHi pvuppala ,
It sounds good, but based on my experience, it's manageable only when you have a few connections. In reality, when dealing with a larger scale—like in our case, with thousands of connections and dozens of gateways—it becomes difficult to manage. If something goes wrong, it could significantly impact the business.
Thanks,
Sai Teja