cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pkumar Helper II
Helper II

How to connect power app with sql database?

Hello,

 

I am trying to connect the power app the sql data base through teamviewer with my office system but it not get connected and data is not get pulled on the app. SQL server is connected within the office network on-prem.

picturemessage_ha0gztzj.wtu.png

From the office if I test the app it working fine on my system and pulled the data correctly. Can anybody please help out how I can resolve this issue?

1 REPLY 1
Dual Super User
Dual Super User

Re: How to connect power app with sql database?

To connect to a SQL database on-premises you have to use the on-premises data gateway.  You can't connect to it through TeamViewer.  Here's a blog post on how to connect to SQL using the on-premises gateway.

https://blogs.msdn.microsoft.com/suvidha/2017/01/03/powerapps-with-sql-server-on-premises-using-the-...



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (8,262)