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.
Hi bergen288,
Just to double check. That address looks like it is a privately hosted database and not an Azure SQL database, correct?
As far as I understood the Connect Directly (Cloud services) option was for Azure SQL databases. But I might be wrong.
And when you say the Power BI SQL connection was working what do you exactly mean? Did you connect to the database from the Power BI desktop application on your local network?