Forum Discussion
Solved
Custom query with CTE not supported (bug?)
Is creating a custom query using a CTE officially not supported or am I just duing it wrong? It works in Query Editor, but you cannot close and apply. I suspect it is becuse the query seems to be e...
I ran into this issue when attempting to use Direct Query Mode. As Qiuyun has said, you can use import mode as a way around this but then you obviously have the timing issues with the data set being dependent upon being refreshed (not live).
I ended up having to build most of my data sets in SQL server using views etc and then direct connect to those.
So, it seems CTEs are only supported in Import mode and not in Direct Query. Still the case?
To be fair I have not tested recently. But I have not seen an update on the matter from Microsoft. I will test again when I have some time and post and update here.