Forum Discussion
BadGateway error with SQL connector in Power Apps
Hi, bergen288
You can install the local gateway standard mode (enterprise gateway) to use the same gateway in Power BI and Power Apps:
Manage an on-premises data gateway in Power Apps - Power Apps | Microsoft Learn
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I asked wrong question because of wrong option. This time, I choose "Connect using on-premises data gateway" instead of "Connect directly". However, there is no gateway installed and if I click "install gateway", it brings me to microsoft Power Apps website: Microsoft Power Apps – Build Apps with AI | Microsoft. There is nothing about gateway installation. If I click "Sign in", then it brings me to my Power Apps home page. Because of no installed gateway, "Connect" icon is greyed out.
Actually, my company won't allow me to install any software on my laptop without approval while it is extremely hard to get something approved. There is a setup of SQL gateway for JWPKSQLEP02.corp.checkfree.com in my Power BI web service as shown below. My new question is how to connect to SQL in Power Apps with the SQL gateway in my Power BI web service?