cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bdmlc Frequent Visitor
Frequent Visitor

Re: Custom query with CTE not supported (bug?)

You can work around it with a sub-query (just move the CTE in to your main query as a sub-query), which is crude and very SQL2K'ish but that is the world we live in, apparently.

adrez86 Regular Visitor
Regular Visitor

Re: Custom query with CTE not supported (bug?)

@v-qiuyu-msft  Was there ever a response/feedback internally on this?

bjcw0 Frequent Visitor
Frequent Visitor

Re: Custom query with CTE not supported (bug?)

I don't think offically. I was able to work around it with making the query into a view and then selecting from there.

EVEAdmin Member
Member

Re: Custom query with CTE not supported (bug?)

So, it seems CTEs are only supported in Import mode and not in Direct Query. Still the case?

bjcw0 Frequent Visitor
Frequent Visitor

Re: Custom query with CTE not supported (bug?)

To be fair I have not tested recently. But I have not seen an update on the matter from Microsoft. I will test again when I have some time and post and update here.

Highlighted
andrewt Regular Visitor
Regular Visitor

Re: Custom query with CTE not supported (bug?)

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). 

OnePunchPanda Frequent Visitor
Frequent Visitor

Re: Custom query with CTE not supported (bug?)

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

tunafish73 Frequent Visitor
Frequent Visitor

Re: Custom query with CTE not supported (bug?)

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.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,240)