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.
Still an issue in April 2020 version. Hopefully they will fix this issue soon. I do appreciate the workarounds in the thread. If you have permissions to to create a view, you can copy your CTE in the SELECT/FROM block of the view, as someone mentioned above.
Still an issue in May 2020. Wonder if this was brought up internally. It's been almost four years from first post.