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