How to integrated Azure in powerplatform.

Question

Connect Azure database to powerapps as currently unable to connect

Answer 1

Hi @Gudivaka, Chandra Sekhar

You can definitely integrate Azure databases with Power Platform (PowerApps, Power Automate, etc.), but the steps depend on the specific Azure service you’re trying to connect. Let me give you the common scenarios:

Azure SQL Database

• PowerApps natively supports Azure SQL as a data source.
• In PowerApps Studio, go to Data > Add data, search for SQL Server connector.
• Provide:
  • Server name and database name
  • Authentication type: SQL authentication or Azure AD
  • Make sure your SQL database firewall allows Azure services and the required IP ranges.

Note: If your SQL database is secured with Private Endpoint, you will need to use an on-premises data gateway for PowerApps to connect.

Azure Cosmos DB

• Use the Cosmos DB connector in PowerApps.
• Select the appropriate API type (SQL API, MongoDB API, etc.)
• Enter your connection keys.

Azure Data Lake

• Currently, PowerApps connects to Azure Data Lake through Dataverse or Power BI datasets, not directly.
• You can prepare data in Synapse or Power BI and surface it through PowerApps.

Important:

If your Azure resources are secured in a VNET (like Private Link or Firewall enabled), you'll likely need an on-premises data gateway for PowerApps to connect.

Make sure your Azure database allows connections from Power Platform IP ranges. You can refer to Power Platform IP addresses.

If you could share:

• Which Azure database you’re using?
• Whether it's secured with firewall or private endpoint?

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.