Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

Error on using SQL Connector for Azure Data Explorer (ADX)

Hello community,


as of 2 weeks ago, when using the Power BI Desktop (Version: 2.119.870.0), I have most of the time problems executing data refresh regarding those tables that make use of the SQL Connector for the Azure Data Explorer.


- Deleting all connection configuration and login anew sometimes helps but not always.

- Disable parallel loading of tables seemed to help, but it did not

- Limiting the data read in seemed to help, but it did not

- setting a timeout on the SQL query (e.g. 1 minute) did not result in a successful execution


It can be be observed that connecting to the ADX and also reading data is working just as it supposed to do (and it did so for the last 12 months perfectly with the exact settings), 


But until approx. two agao, I always get these kind of errors


Has anyone an idea, why the remote host is closing the connection?

I tested connection with Kust.Explorer and Azure Data Explorer on desktop - no problems at all.




Frequent Visitor

Hi, @v-eqin-msft ,


thank you very much for your reply.

The solution to me was to eliminate all queries using SQL Connector and just make use of kusto query language (KQL).


Maybe of interest to others:
Use the "explain" keyword on top of the SQL query in the Kusto.Explorer to translate an SQL query to KQL



Best Regards

Community Support
Community Support

Hi, @stanbeamish 


Please refer to the following links hope it helps.

Solved: OLE DB or ODBC error: [DataSource.Error] - Microsoft Fabric Community

Dataverse connection error - Microsoft Fabric Community

A transport-level error has occurred when receivin... - Microsoft Fabric Community


Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.