CTE don't work in Direct Query Mode

[Anonymous]

Hi,

I have CTE and when I executed on Power Query it loads the data but when close&Apply it throw error - like " incorrect Syntax ....."

Is CTE not supported in direct query mode in Power BI?

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
It is a known issue for a long time.

Please refer to the linked discussion

https://community.fabric.microsoft.com/t5/Desktop/Custom-query-with-CTE-not-supported-bug/m-p/41395

Please consider Accepting it as the solution to help the other members find it more quickly