Error using Azure Data Explorer Connector from Power Automate

Question

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

Answer 1

Hello Gerald

I'm Diane, a Microsoft 365 Apps & Services MVP and I'll try to help you today.

Sorry to hear you're experiencing this issue.

This forum is targeted to end-users, not admin issues and while some of us can answer some of these questions, the new Q&A forums are better suited for these questions.

https://docs.microsoft.com/en-us/answers/products/office

Unfortunately, moderators are unable to move messages to that forum, so you'll need to repost it.

-- Diane

Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.