Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Power BI direct query

Hello,   I have a query that I added a CTE to and I get the following message:   Incorrect syntax near ';' and incorrect syntax near ')'.   If I take the CTE out, it works fine.  The query runs f...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi Anonymous,

     

    Based on my research, this should be a known issue. And I have reproduced the issue in DirectMode.

     

     

    In addition, there is an idea about adding this function, you can vote it up.

     

    Regards,

    Frank

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Frank,

 

Thanks for the info.   I voted the issue up.  Hopefully this will be addressed.  CTEs are essential for the queries we write.

 

Thank you!