cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
senthilkan
Level: Power Up

Can PowerApps application connect to Azure SQL Database Managed Instance

Can PowerApps application connect to Azure SQL Database Managed Instance?

 

I have exisiting PowerApps application that connects to SQL database hosted in Azure VM server.  Planning to move Database to new Azure SQL Database Managed Instance.  I am reading through this link [https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-connect-app] for different type of connections from Client Applications. PowerApps connectivity is not mentioned. Any pointers would be helpful.

1 REPLY 1
Super User
Super User

Re: Can PowerApps application connect to Azure SQL Database Managed Instance

I have not tried doing it with a managed instance, but I have done a SQL Connector to a regular Azure SQL database (SAAS not IAAS). If you look at the properties of the SQL Instance you should see a server name.  Use that in the regular SQL connector with the database name and it should work. Note: you will need to have setup the managed instance with a proxy to the Internet.  Otherwise it won't be reachable.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.