Forum Discussion

jsBrizius's avatar
jsBrizius
Helper I
10 years ago
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...
Need Help
  • WESTi's avatar
    WESTi
    10 years ago

    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.

RichardBroadley's avatar
RichardBroadley
Frequent Visitor
6 years ago

This is still an issue. CTE's in Direct Query mode work in Preview but errors when you try and use it. As far as I can see, the 'solution' is that it's been raised with Microsoft. Is there an update? Are Microsoft going to fix this?

  • jmccroddan's avatar
    jmccroddan
    Regular Visitor
    6 years ago

    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. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Still an issue in May 2020. Wonder if this was brought up internally. It's been almost four years from first post.