Answered

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

Like (1) Share

Report

Posted on 28 Sep 2018 14:34:48 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:

Connecting to Data

General Questions

Connectors

All responses (2)

Answers (1)

Verified answer

v-xida-msft on 02 Oct 2018 at 00:59:08

Like (0)

Report

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

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
timl 35,109 Super User 2025 Season 1 on 28 Sep 2018 at 14:55:30

Like (0)

Report

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

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/