Solved! Go to Solution.
You need to connect on-premise SQL Server to Data Gateway then use SQL Server. You'll select the named Gateway. The Gateway will show this once you have connected to on-premise SQL Server.
Yeah I discussed with them but they answered me that PowerApps is based on Cloud so thats why I can't connect to the SQL that is blocked from connections outside the same network company o.o
So now I am in doubt how to solve this x.x
I'm not understanding. Were you able to connect to SQL Server using On-Premise Data Gateway? If you can connect then you should be able to see data gateway from PowerApps.
I tried to connect on PowerApps here:
connect directly based on cloud
maybe gateway is my solution here?
You need to connect on-premise SQL Server to Data Gateway then use SQL Server. You'll select the named Gateway. The Gateway will show this once you have connected to on-premise SQL Server.
Ok I will try it tomorrow on my company..
Thanks!
OK I DID it, but Now i dont know what to do, I tried to connect on PowerApps using the GateWay and got a licence error, but my licence is Dynamics....
I cant extend my plan 2 to test also :C
I have a Business 365 license that comes with PowerApps and for right now free use of the Gateway. They just announced they plan to charge for the Gateway starting 2/1/2019. You probably need to check with support if Dynamics includes use of Gateway.
I'm just using Gateway to develop app. I find the use of the SQL Profiler VERY useful in figuring what PowerApps is doing and improving performance. I plan to move to Azure SQL DB. I can get by with Basic plan and don't want headache of managing server.
User | Count |
---|---|
137 | |
132 | |
79 | |
75 | |
72 |
User | Count |
---|---|
210 | |
200 | |
69 | |
63 | |
53 |