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