Skip to main content

Power BI

Needs Votes

Improve Direct Query Date Time Handling

Vote (726) 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

Astrid Aguirre on 05 May 2021 11:59:22

RE: Improve Direct Query Date Time Handling

Please take a look on this - causes so much re work!

Sam Bloggs's profile image Profile Picture

AJ Hudak on 25 Jan 2021 17:44:51

RE: Improve Direct Query Date Time Handling

Also critical: hierarchy dates for charts!

Sam Bloggs's profile image Profile Picture

Derson Andrade on 18 Aug 2020 22:17:59

RE: Improve Direct Query Date Time Handling

must need option

Sam Bloggs's profile image Profile Picture

Hiren Panchal on 10 Jul 2020 17:21:45

RE: Improve Direct Query Date Time Handling

Please look into this ASAP.

Sam Bloggs's profile image Profile Picture

Power BI User on 06 Jul 2020 00:14:54

RE: Improve Direct Query Date Time Handling

Please add this! Agree wholeheartedly that Direct Query & Import modes should have the same date handling functionality!!!

Sam Bloggs's profile image Profile Picture

sasi@gmail.com on 06 Jul 2020 00:13:35

RE: Improve Direct Query Date Time Handling

Please add DATE HIERARCHY in Direct Query mode also. Why there is such a difference in import and direct query mode. Too much difficulty in handling such situation.

Sam Bloggs's profile image Profile Picture

Kevin on 06 Jul 2020 00:13:02

RE: Improve Direct Query Date Time Handling

I do not understand why direct query acts differently than import. This needs to be fixed. I am spending silly amounts of time trying to work around it.

Sam Bloggs's profile image Profile Picture

RB on 06 Jul 2020 00:12:37

RE: Improve Direct Query Date Time Handling

Import and DirectQuery data connectivity modes should have the same common functionality of Date/Calendar hierarchy. This is so overdue from Power Bi team. Please consider implementing it as soon as possibly can.

I would rank this request from user community above all new futures released monthly.

Sam Bloggs's profile image Profile Picture

Power BI User on 06 Jul 2020 00:08:14

RE: Improve Direct Query Date Time Handling

This is an absolute necessity. Please please fix this.

Sam Bloggs's profile image Profile Picture

Power BI User on 06 Jul 2020 00:08:09

RE: Improve Direct Query Date Time Handling

Please, Please, Please....this is the one functionality that makes me want to use Tableau!