Forum Discussion
stanbeamish
3 years agoFrequent 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...
stanbeamish
3 years agoFrequent Visitor
Hi, Anonymous ,
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