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 no...
I was under the impression that "Power Query is the same in Excel and Power BI". Now I find that the corpus of CTEs from the Excel PQ world is not usable in Direct Query mode of PBI. This is a very frustrating user experience that violates the principle of least astonishment. Please fix.
