Power Platform Community Forum Thread Details

Hi,

I'm trying to execute SQL stored procedures on Azure SQL DW using Power Apps as front end and in backend Power Automate.
I'm accepting stored procedure parameters in Power Apps and passing it to Power Automate flow.

My flow is failing due to 504: Bad Gateway error.
Here is input and output of failed steps of flow.

-------------------------------Input----------------------------

{

"host": {

"connectionReferenceName": "shared_sqldw",

"operationId": "ExecuteProcedure"

"parameters": {

"procedure": "[rpt].[sp_xxxxxxxxx]",

"parameters/DateFrom": "02/05/2022",

"parameters/DateTo": "11/05/2022"

}

-------------------------------Output----------------------------

{

"statusCode": 504,

"headers": {

"Pragma": "no-cache",

"x-ms-datasourceerror": "True",

"x-ms-request-id": "49e5182f-fab3-462b-yyyy-xxxxxxxxxxx",

"Strict-Transport-Security": "max-age=31536000; includeSubDomains",

"X-Content-Type-Options": "nosniff",

"X-Frame-Options": "DENY",

"Cache-Control": "no-store, no-cache",

"Set-Cookie": "ARRAffinity=9227faf24135ad53dd065beee547fecb0ff01774dd3486105eba5bed7b415073;Path=/;HttpOnly;Secure;Domain=sql-we.azconn-we.p.azurewebsites.net,ARRAffinitySameSite=9227faf24135ad53dd065beee547fecb0ff01774dd3486105eba5bed7b415073;Path=/;HttpOnly;SameSite=None;Secure;Domain=sql-we.azconn-we.p.azurewebsites.net",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "true",

"x-ms-apihub-obo": "true",

"Date": "Wed, 11 May 2022 08:21:13 GMT",

"Content-Length": "687",

"Content-Type": "application/json",

"Expires": "-1"

"body": {

"error": {

"code": 504,

"source": "flow-apim-europe-001-westeurope-01.azure-apim.net",

"clientRequestId": "49e5182f-fab3-462b-yyyy-xxxxxxxxxxx",

"message": "BadGateway",

"innerError": {

"status": 504,

"message": "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nclientRequestId: 49e5182f-fab3-462b-yyyy-xxxxxxxxxxx",

"error": {

"message": "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

"source": "sql-we.azconn-we.p.azurewebsites.net"

}

}

power automate error.jpg