Skip to main content

    Power BI

    New

    Custom cte Query in Direct Query Power Bi

    Vote (55) Share
    's profile image

    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 (13)
    's profile image Profile Picture

    fefe1a47 1579-4cc6-9625-89f799c43263 on 05 Jul 2020 23:24:40

    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.

    's profile image Profile Picture

    5832a18c 49df-4733-ac5f-403667f0ff42 on 05 Jul 2020 23:15:58

    RE: Custom cte Query in Direct Query Power Bi

    Please give us a solution to this issue, we need cte in ours querys.

    's profile image Profile Picture

    13db98ce 2e43-49be-b860-98679c3a1e56 on 05 Jul 2020 23:08:29

    RE: Custom cte Query in Direct Query Power Bi

    Please fix this, such a pain