Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

KQL query not working in Dataflow

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.

Dataflow
Need Help

1 Reply

  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    Community Support
    2 years ago

    Hi Anonymous ,

     

    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.