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.

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.