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...
Wow I was just writing a big cte and figured I better check if I was going to be able to use it, back to the drawing board...
