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.
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.
Greetings
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
e.g.
Best Regards
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
106 | |
87 | |
77 | |
69 |
User | Count |
---|---|
124 | |
112 | |
94 | |
84 | |
75 |