Content migrated from TechNet. Post attribution to: BlackD1ece
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).
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.
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.
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.
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:
3. Modify the connection string. You should be able to see table list in PowerApps.