cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
2makeitwork
Frequent Visitor

Badgateway 502 error Azure Synapse connection

Hello,

 

I created a connection to my Azure Synapse SQL table that has a PK column in the table. In the Powerapps canvas, the default EditScreen1 showed up enabling me to edit or create new record to the SQL table. However, when I try to do that, using all default codes, I get the Badgateway error. This is the first time I'm trying to connect to Azure SQL so any help is appreciated on how to fix this problem. Thanks! 

 

"body": {
"error": {
"code": 502,
"source": "europe-001.azure-apim.net",
"clientRequestId": "336045d5-7267-4878-abcc-d5cc0826635f",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "Parse error at line: 1, column: 60: Incorrect syntax near 'OUTPUT'.\r\nclientRequestId: 336045d5-7267-4878-abcc-d5cc0826635f",
"error": {
"message": "Parse error at line: 1, column: 60: Incorrect syntax near 'OUTPUT'."
},
"source": "sql-we.azconn-we.p.azurewebsites.net"
}

0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,581)