Error using Azure Data Explorer Connector from Power Automate

Gerald Omife 1 Reputation point
2022-11-18T08:01:09.05+00:00

Hi all,

Please who knows why I am getting this error ? I am trying to run a simple query on my ADX Cluster Database from Power Automate.

The dynamic operation request to API 'kusto' operation 'listKustoResultsSchemaPost' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "flow-apim-europe-002-westeurope-01.azure-apim.net", "clientRequestId": "85509885-e451-46d9-b070-72d13806e5c1", "message": "BadGateway", "innerError": { "ClassName": "Kusto.Data.Exceptions.KustoClientException", "Message": "clientRequestId: 85509885-e451-46d9-b070-72d13806e5c1", "Data": null, "InnerException": { "ClassName": "System.Net.WebException", "Message": "Unable to connect to the remote server", "Data": null, "InnerException": { "NativeErrorCode": 10060, "ClassName": "System.Net.Sockets.SocketException", "Message": "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond", "Data": null, "InnerException": null, "HelpURL": null, "StackTraceString": " at System.Net.Sockets.Socket.InternalEndConnect(IAsyncResult asyncResult)\r\n at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)\r\n at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)", "RemoteStackTraceString": null, "RemoteStackIndex": 0, "ExceptionMethod": "8\nInternalEndConnect\nSystem, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\nSystem.Net.Sockets.Socket\nVoid InternalEndConnect(System.IAsyncResult)", "HResult": -2147467259, "Source": "System", "WatsonBuckets": null }, "HelpURL": null, "StackTraceString": " at System.Net.HttpWebRequest.EndGetRequestStream(IAsyncResult asyncResult, TransportContext& context

Regards

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,604 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2022-11-18T13:52:13.227+00:00

    Power automate is not currently supported here on Q&A. The product group for Power automate actively monitors questions in dedicated forums here.
    https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    --please don't forget to upvote and Accept as answer if the reply is helpful--

    0 comments No comments