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...
my company has decided to pass on tableau and use powerBi instead, i feel like this is such a huge mistake as i've never had issues with even temp tables in tableau, and now this is just silly that i have to create a view for each dashboard for a direct connection..even if its just a simple query???..... wow what a step backwards.
