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...
To Power BI developers: The ability to write a query using CTEs is an absolute must. We are looking at adding Power BI to our menu to roll out to our customer base with access to pre-defined templates. We need the ability to write proper queries. Please add this to your bucket list to address. Thank you.
