CODEWITHSUNDEEP
azureazure-sql-databasepowerappspower-automate
huju vert
huju vert

Reputation: 33

Azure SQL DB and Power Apps/Power Automate Private Connectivity

I have created an Azure SQL DB, with the public access off, and private endpoint created for private connectivity.

I am trying to access the Azure SQL DB via Power Apps and Power Automate, but each time, it fails to connect and asks me to whitelist the 'public' ip in the Azure SQL DB firewall. I am not fond of this approach of whitelisting public IPs.

Is there any other way to connect Azure SQL DB from Power Apps privately?

Upvotes: 1

Views: 5092

Answers (2)

Antonio Buonaiuto
Antonio Buonaiuto

Reputation: 155

To enable PowerApps to reach a DB using a Private Endpoint you should follow this answer: https://learn.microsoft.com/en-us/answers/questions/1375832/power-apps-automate-and-azure-sql-db-connection-wi

Here a brief summary:

  • go to the SQL Database in Azure Portal
  • on the left side choose PowerPlatform/Power Apps
  • configure required fields
  • click to create

Upvotes: 0

Bhavani
Bhavani

Reputation: 5252

As per this SQL database don't grant access more than 255 IP address. To connect Azure SQL database with Power Apps by using private endpoint, disable public access in SQL server networking settings.

enter image description here

Create virtual network and add the required Ip address of PowerApps to the subnet

enter image description here

Create private endpoint for azure sql server with created vnet and subnet and approve it.

enter image description here

Try to connect database with PowerApps by entering the required details of server. By disabling public access, you won't get notification of whitelisting the IP address. For more information you can refer this.

Upvotes: -1

Related Questions