KQL query not working in Dataflow

[psyche_2108]

I am having this error in Power BI Dataflow when connecting to ADX (Azure Data Explorer).
The query that I'm using works perfectly in azure data explorer as well as in Power BI desktop.
It just throws this error in dataflow connection.

Error:
An exception occurred: Bad request: Request is invalid and cannot be processed: Syntax error: SYN0002: The incomplete fragment is unexpected. [line:position=2:1] (Session ID: 037359cb-a0ed-4051-aea6-c8b6c6457e7a, Region: us)

Any help is truly appreciated.

[v-weiyan1-msft]

Hi @psyche_2108 ,

Based on the error message you shared, it appears that you have encountered a "Syntax error: SYN0002". This error usually indicates that there is a syntax problem in the query, where an incomplete fragment or expression is unexpected at the specified location in your query.
Please check the syntax of query , especially the position mentioned in the error message (line:position=2:1). Look for any incomplete fragments or expressions that may not be fully compatible or supported in the Power BI Dataflows.
You can also try to simplify the query or break it down into smaller parts to identify the specific piece that is causing the problem. This can help isolate the problematic part of the query.

Best Regards,
Yulia Yan

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