Announcements
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
You can access internal SQL Servers by installing the on-premises data gateway. Here is a link to more information.
https://powerapps.microsoft.com/en-us/blog/connect-to-your-on-premises-data-sources-using-on-premises-data-gateway-from-powerapps/
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:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabase
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324
