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.

Helpful resources


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

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


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 215 members 3,224 guests
Please welcome our newest community members: