Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors