Custom cte Query in Direct Query Power Bi

[Srividya]

In Power Bi a custom cte query in DirectQuery is giving issues.This feature has to be enabled.As a workaround we can use import mode but when live data is required directquery has to be used.Right now this is not supported.

[wtsai]

I feel this issue has already existed for more than 2 years. When will Microsoft take action??

[mat_mcdonough]

Just spent half a day wriing a complex query usign CTEs in power query (excel) and then come to power BI to implement...

[phe345]

Please implement a solution as this has been a known issue/request for over 4 years.

[lorenray1]

Please, please, please start supporting cte's. We should not be having to grant privileges to write views when cte's can do the trick. I know the solution should be 'close' as we can see our data perfectly in Power Query! I just want to be able to successfully 'close and apply', then use my data!

[billy_m]

It seems insane that this feature (still) does not exist. Like many here, spent hours writing a series of complex queries using CTEs and then they don't work...

My frustrations using Power BI are mounting, and as much as I hate Tableau I'd rather be using that at this point. Considering advising my Azure client to stop paying for these licenses, and to use another product. So frustrating.