Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Improve Direct Query Date Time Handling

    Vote (700) 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 (77)
    Sam Bloggs's profile image Profile Picture

    Brenda Johnston on 05 Jul 2020 23:48:46

    RE: Improve Direct Query Date Time Handling

    Help, I really need the date hierarchy with direct query.

    Sam Bloggs's profile image Profile Picture

    Laurent on 05 Jul 2020 23:47:25

    RE: Improve Direct Query Date Time Handling

    Yes. This is limiting drill-down capability with Direct Query.

    Sam Bloggs's profile image Profile Picture

    Praveenraj.k 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

    Jeyakumar Seenivasagam 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

    Jennifer Iler on 05 Jul 2020 23:46:38

    RE: Improve Direct Query Date Time Handling

    Need this now!!

    Sam Bloggs's profile image Profile Picture

    Denis 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

    Power BI User 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

    Power BI User 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

    Francisco 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

    Victor Spence on 05 Jul 2020 23:39:09

    RE: Improve Direct Query Date Time Handling

    Please add Date Hierarchy to DQ.