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...
E X A C T L Y ! Data analysis and reporting (as opposed to simple CRUD operations) are when CTEs and temp tables come in most handy. Power BI, which exists for the purpose of analysis & reporting, isn't much useful if it only supports simple CRUD operations.
