Unanswered

Can I use a local or on-site SQL Server for PowerApps data?

(1) Share

Report

Posted on by Community Power Pla...

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No