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

    4d8902cb a166-4415-a6d3-c5b2ba5696a4 on 05 Jul 2020 23:47:21

    RE: Improve Direct Query Date Time Handling

    Hi PowerBI Team, I'm handling the bulk of time series data, if date hierarchy is available in the direct query, it will be more helpful to us

    Sam Bloggs's profile image Profile Picture

    28e3c8b6 24e0-4187-8d09-9dd912463daf on 05 Jul 2020 23:47:17

    RE: Improve Direct Query Date Time Handling

    Power BI team, Please consider this feature in the upcoming release.

    Sam Bloggs's profile image Profile Picture

    fd9bb193 1416-463c-a128-e2a4d4799212 on 05 Jul 2020 23:46:38

    RE: Improve Direct Query Date Time Handling

    Need this now!!

    Sam Bloggs's profile image Profile Picture

    f66d2d53 39d7-48f6-a63a-a6108b6426af on 05 Jul 2020 23:45:18

    RE: Improve Direct Query Date Time Handling

    Please add date hierarchy in direct query mode. Thankyou.

    Sam Bloggs's profile image Profile Picture

    83e70349 eaaf-4ba8-9b07-77ab9776450f on 05 Jul 2020 23:43:11

    RE: Improve Direct Query Date Time Handling

    please add date hierarchy in direct query mode

    Sam Bloggs's profile image Profile Picture

    45c2c716 6af0-4925-bb5f-360a37f45a4b on 05 Jul 2020 23:41:17

    RE: Improve Direct Query Date Time Handling

    This is very useful tool and not having it on direct query is making reports very hard to develop.

    Please correct this problem ASAP.
    RL 2/15/2019

    Sam Bloggs's profile image Profile Picture

    35990076 25bc-4d99-8838-76222713a566 on 05 Jul 2020 23:40:47

    RE: Improve Direct Query Date Time Handling

    Totally agree with this. This feature is much needed. Please fix it soon!

    Sam Bloggs's profile image Profile Picture

    f61782bf 719d-44cb-b59e-d37772c98d55 on 05 Jul 2020 23:39:09

    RE: Improve Direct Query Date Time Handling

    Please add Date Hierarchy to DQ.

    Sam Bloggs's profile image Profile Picture

    c6a6594e 2b3c-e811-a955-000d3a1be7ad on 05 Jul 2020 23:38:52

    RE: Improve Direct Query Date Time Handling

    Definitely agree

    Sam Bloggs's profile image Profile Picture

    4dd029e8 3a82-47cb-8a74-f39b50aee82b on 05 Jul 2020 23:38:20

    RE: Improve Direct Query Date Time Handling

    Please add Date Hierarchy to DQ.