Skip to main content

    Power BI

    Needs Votes

    Improve Direct Query Date Time Handling

    Vote (420) Share
    Sam Bloggs's profile image

    Sam Bloggs on 14 Jun 2016 21:06:14

    When using direct query you should be able to change a date axis to show only the month. This works using excel or when doing a transform but neither of these are possible using DirectQuery. Even workarounds like FORMAT can't be used with direct query. This really needs fixing!

    Comments (55)
    Sam Bloggs's profile image Profile Picture

    41f1e43e e8ba-4b2e-8b48-e0ebc4fab23c on 05 Jul 2020 23:36:43

    RE: Improve Direct Query Date Time Handling

    Please add DATE HIERARCHY in Direct Query mode. This is crucial for me.

    Sam Bloggs's profile image Profile Picture

    e411aa84 b62c-4635-b015-a4556fb39020 on 05 Jul 2020 23:36:10

    RE: Improve Direct Query Date Time Handling

    Agree, please fix this soon or I will be forced to use tableau :(

    Sam Bloggs's profile image Profile Picture

    62043724 7fe4-4ed6-b736-9ec4f17d0462 on 05 Jul 2020 23:34:36

    RE: Improve Direct Query Date Time Handling

    Auto hierarchy would be a huge benefit.

    Sam Bloggs's profile image Profile Picture

    1df2d66d d60b-470a-9a46-1d677dfd0174 on 05 Jul 2020 23:29:45

    RE: Improve Direct Query Date Time Handling

    Auto creating the hierarchy would be nice too.

    Sam Bloggs's profile image Profile Picture

    cad5b767 6d84-49b9-8118-ae6abaeb0630 on 05 Jul 2020 23:23:27

    RE: Improve Direct Query Date Time Handling

    Please fix this soon.

    Sam Bloggs's profile image Profile Picture

    25f98cbe eb6b-4ef8-a504-7db86c2f7b21 on 05 Jul 2020 23:17:56

    RE: Improve Direct Query Date Time Handling

    Please add this feature, it would be really handy.

    Sam Bloggs's profile image Profile Picture

    0a55ccff 0d4f-40c1-b6ce-e42022e3804a on 05 Jul 2020 23:15:36

    RE: Improve Direct Query Date Time Handling

    This request is represented twice (https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16835431-automatic-date-hierarchy-for-direct-query-data), and both register a high number of votes. Please consider this in the next prioritization cycle, as this is foundational functionality.

    Sam Bloggs's profile image Profile Picture

    fa038cdc 18cd-4a46-92df-dc8c98da0bee on 05 Jul 2020 23:15:35

    RE: Improve Direct Query Date Time Handling

    This feature is much needed. Please make it happen!

    Sam Bloggs's profile image Profile Picture

    142ea590 8f81-4a80-92a1-d86f8c9aa760 on 05 Jul 2020 23:15:33

    RE: Improve Direct Query Date Time Handling

    Totally agree with this

    Sam Bloggs's profile image Profile Picture

    0a90dba6 2399-ea11-a811-000d3a4e3654 on 05 Jul 2020 23:15:27

    RE: Improve Direct Query Date Time Handling

    Totally agree with this. I just spent half a day trying to hack a way to do this, only to find it was the direct query killing things.

    You're gonna have to add this if you want to claim you support interactive analytics.