Power BI

Needs Votes

Improve Direct Query Date Time Handling

Vote (700)

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 (76)

Comments (76)

Jacob Arpe on 05 Jul 2020 23:38:20

RE: Improve Direct Query Date Time Handling

Please add Date Hierarchy to DQ.

Salih Yasin 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.

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

Todd on 05 Jul 2020 23:34:36

RE: Improve Direct Query Date Time Handling

Auto hierarchy would be a huge benefit.

Curran Davis on 05 Jul 2020 23:29:45

RE: Improve Direct Query Date Time Handling

Auto creating the hierarchy would be nice too.

Justin on 05 Jul 2020 23:23:27

RE: Improve Direct Query Date Time Handling

Please fix this soon.

Instarea on 05 Jul 2020 23:17:56

RE: Improve Direct Query Date Time Handling

Please add this feature, it would be really handy.

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.

Power BI User on 05 Jul 2020 23:15:35

RE: Improve Direct Query Date Time Handling

This feature is much needed. Please make it happen!

Sukhomoy Bhattacharya on 05 Jul 2020 23:15:33

RE: Improve Direct Query Date Time Handling

Totally agree with this