Hi Power Automate Support Team,
I am encountering an issue with one of my Power Automate flows that executes a Kusto query. The flow fails with the following error message:
"statusCode": 400,
"headers": {
"Cache-Control": "no-store, no-cache",
"Pragma": "no-cache",
"Set-Cookie": "ARRAffinity=b9821e690af9852610f8eeeca3309b727f1b53f90b47715d212bd0be30459022;Path=/;HttpOnly;Secure;Domain=kusto-cus.azconn-cus-001.p.azurewebsites.net,ARRAffinitySameSite=b9821e690af9852610f8eeeca3309b727f1b53f90b47715d212bd0be30459022;Path=/;HttpOnly;SameSite=None;Secure;Domain=kusto-cus.azconn-cus-001.p.azurewebsites.net",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"x-ms-request-id": "3e33c036-8fdc-4655-a555-561b32856297",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Mon, 22 Jul 2024 19:34:42 GMT",
"Content-Length": "167",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"message": "Query execution has exceeded the allowed limits of 50000 max records or max size of 32 MB\r\nclientRequestId: 3e33c036-8fdc-4655-a555-561b32856297"
}
}
It seems that the query execution exceeds the allowed limits of 50,000 maximum records or a maximum size of 32 MB. While the query runs successfully in Kusto Explorer, it breaks the flow in Power Automate due to this limitation.
Could you please assist in resolving this issue? Specifically, I need help with the following:
Your prompt assistance in this matter would be greatly appreciated, as this issue is currently blocking our workflow.
Thank you for your support.
Youssef