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 have a number of queries that use CTEs that run just fine in sql server. then imagine the frustration and time lost (that's the major issue) in trying to get Power BI to accept the query (direct connect), then realizing you've got to basically rewrite the code (if you can) with embedded subqueries (this is very difficult to do and virtually impossible to follow once you've done it). I cannot create views. This is something that users need and expect. PLEASE fix this. Thanks
