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 just ran into this issue. You can get a review in Power Query but once you Close & Apply you get errors about semicolons.
