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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Still an issue in March 2024.  This is a bug and needs to be fixed.  Using import is not a work around for a lot of applications.

DimaN's avatar
DimaN
New Member
2 years ago

My current workaround is using subqueries, but of course gets a bit ugly structure-wise... Microsoft: please add CTEs to directquery - what's the problem with solving this "bug"?