Forum Discussion
CTE don't work in Direct Query Mode
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?
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
1 Reply
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