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
7 years ago

Why is this issue marked "Solved"?  Power BI still throws an error when closing the Query Editor for any query containing a CTE (which seems pretty insane given the amount of time this has been a known issue). 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Confirming this is still an issue 5 months from last post for anyone coming across this thread!

  • tunafish73's avatar
    tunafish73
    Frequent Visitor
    6 years ago

    Agreed. The workaround given earlier in this thread creates a table that is in import mode, so no improvement on using import mode in the first place that I can see.