on 21 Jul 2017 11:25:10
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 now this is not supported.
- Comments (15)
RE: Custom cte Query in Direct Query Power Bi
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.
RE: Custom cte Query in Direct Query Power Bi
I was under the impression that "Power Query is the same in Excel and Power BI". Now I find that the corpus of CTEs from the Excel PQ world is not usable in Direct Query mode of PBI. This is a very frustrating user experience that violates the principle of least astonishment.
Please fix.
RE: Custom cte Query in Direct Query Power Bi
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.
RE: Custom cte Query in Direct Query Power Bi
Please give us a solution to this issue, we need cte in ours querys.
RE: Custom cte Query in Direct Query Power Bi
Please fix this, such a pain