Forum Discussion

bergen288's avatar
bergen288
Helper IV
1 year ago
Solved

BadGateway error with SQL connector in Power Apps

Below is the screenshot of my SQL connector in Power Apps.  The same credential works fine in Power BI SQL connection, but it gives me following error in Power Apps.  What's wrong with it and how to ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you Expiscornovus 

Hi, bergen288 

Make sure that the name/field/table is referenced correctly, if it is misreferenced it will trigger the issue:

Solved: bad gateway error 502 powerapps - Power Platform Community

Here's the Power Apps Connect to Azure SQL Server documentation, confirm that your steps are OK:

Connect to SQL Server from Power Apps - Power Apps | Microsoft Learn

 

 

Common issues and resolutions for 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.

 

  • bergen288's avatar
    bergen288
    Helper IV
    1 year ago

    Jianpeng:

     

    I will take a look of your links.  Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      HI, bergen288 

      Thank you very much for your reply. Your description and screenshots, which really prove that there is no problem with your credentials. You'll need to check Power Apps' limits on the data source, as I provided earlier, to see if there are any statements that are causing a 502 error when sending a query.

      This may be a correct way to solve the problem.

      Power Automate throwing 502 BadGateway error. - Microsoft Community

       

       

      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.