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.

WESTi's avatar
WESTi
Helper I
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.

  • Vlasz's avatar
    Vlasz
    Advocate I
    9 years ago

    Just wanted to bump this topic.

     

    Please fix this!!!

     

    I use CTE's quite often in my SQL, and re-writing my queries so Power BI will "like" them both adds another step and throws a wrench into my query formatting.

     

    Not to mention how frustrating it is to see your query evaluate, get a preview of your data, and then on the second query evaluation be told that incorrect syntax has been detected.

     

    Thank you

  • Mandr0id's avatar
    Mandr0id
    Advocate I
    9 years ago

    Creating views instead of CTE is not always an option.

     

    Need either CTE ot Temp tables support in PowerBI when creating data sets.