Showing results for 
Search instead for 
Did you mean: 
Level 10

[PowerApps] Connection with an SQL Server

Content migrated from TechNet. Post attribution to: BlackD1ece


Good evening,

I'm starting on trying the new service provided by MS (PowerApps) and I'm not able to connect my SQL Servers to the PowerApp's, as listed on:

And I'm not even close to get the API to work, would like if someone could give me a clue.

First thing is that I log into Azure enviroment and I can't Access PowerApps (while logging in with the APP it lets me).

Also, why is there no option from the app itself to connect to SQL Server enviroments? (Or Dynamics NAV ones).


I tried creating a BBDD on Azure, to use it's connection String to add it to PowerApps, but it keeps telling me "The data did not load correctly. Please try again". I tried with all the strings that Azure CMS gives you, and none is working(Firewall on the server is already allowing my connections).

Any clue?

EDIT: I managed to connect via AZURE with the ADO String obtained through Azure CMS. Still unable to connect to a SQL Server not in Azure enviroment.

Thank you very much, best regards.

Level 10

Re: [PowerApps] Connection with an SQL Server

Hi BlackD1ece,


From the article:


You can connect to SQL Server on-premises. To do it, you need to configure hybrid and leverage existing hybrid networking solutions in Azure.



Let's continue the conversation here.




Level: Power Up

Re: [PowerApps] Connection with an SQL Server

Hello Wendy,


Thanks for the quick reply, 


I actually found that link over my headaches tryin to connect the MS Sql Server to powerapps, the problem is that on my management portal of Azure I got "No permission" to access and manage powerapps from there(So I can't continue from this point :/, actually annoying).


I opened a support ticket to see if this can be solved since I can log-in in powerapps but not from azure, and I'm waiting the response. If you have any clue of what's causing this, I would be very gratefull.


Thank you again, best regards.


PowerApps Staff rekenliu
PowerApps Staff

Re: [PowerApps] Connection with an SQL Server

Accessing PowerApps in Azure portal will be removed soon. Please see the following thread for details:

However, you are still able to connect SQL Azure with the standard PowerApps. Here are steps I shared in anoher post:

1. Use Microsoft SQL Server Management Studio to connect your SQL Azure database first, and ensure the server name, username, and password are all correct.

2. Compose the connection string as below:
Server=yourservername;Database=databasename;User Id=username;Password=password

3. Modify the connection string. You should be able to see table list in PowerApps.



Reken Liu

Re: [PowerApps] Connection with an SQL Server

Is that done within PowerApps?

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 178 members 6,096 guests
Please welcome our newest community members: