We have a vast number of Microsoft SQL Servers at our organization, but they are all of course behind a firewall. How can PowerApps reach these if an app runs from the cloud?
Hi @Anonymous,
Do you want to use On-premise SQL Table as data source of your app?
If you want to access On-premise SQL table from your app, you must firstly install an On-premise data gateway within your computer. More details about installing a On-premise data gateway within your computer, please check the following article:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/gateway-reference
In addition, more details about connecting SQL Server from PowerApps, please check the following article:
Please also check and see if the following video would help in your scenario:
https://www.youtube.com/watch?v=uqx_h4Ym8ng
Best regards,
Kris
Hi @Anonymous
You can access internal SQL Servers by installing the on-premises data gateway. Here is a link to more information.
MS.Ragavendar
27
mmbr1606
14
Super User 2025 Season 1
EE-04041031-0
11