536
S

Improve Direct Query Date Time Handling

Sam Bloggs on 6/14/2016 9:06:14 PM
536
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!
STATUS DETAILS
Needs Votes

Comments

S

S

RE: Improve Direct Query Date Time Handling

Paula Leger on 10/6/2021 4:14:51 PM

Date hierarchy using direct query should have been available from beginning considering how most database data is reported. You shouldn't have to rely on a voting system, waiting for others to realize that this is a big problem.

S

S

RE: Improve Direct Query Date Time Handling

Tristan Ozinga Ozinga on 5/6/2021 9:40:17 AM

I can't believe this functionality is not natively available. The work around of creating new columns and using DAX time functions is laborious to say the least! PLEASE MAKE THIS FEATURE!

S

S

RE: Improve Direct Query Date Time Handling

Timothy Fooks on 5/6/2021 5:20:55 AM

Another comment - because this really needs to be done.

S

S

RE: Improve Direct Query Date Time Handling

Astrid Aguirre on 5/5/2021 11:59:22 AM

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

S

S

RE: Improve Direct Query Date Time Handling

AJ Hudak on 1/25/2021 5:44:51 PM

Also critical: hierarchy dates for charts!

S

S

RE: Improve Direct Query Date Time Handling

Derson Andrade on 8/18/2020 10:17:59 PM

must need option

S

S

RE: Improve Direct Query Date Time Handling

Hiren Panchal on 7/10/2020 5:21:45 PM

Please look into this ASAP.

S

S

RE: Improve Direct Query Date Time Handling

Power BI User on 7/6/2020 12:14:54 AM

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

S

S

RE: Improve Direct Query Date Time Handling

sasi@gmail.com on 7/6/2020 12:13:35 AM

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.

S

S

RE: Improve Direct Query Date Time Handling

Kevin on 7/6/2020 12:13:02 AM

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.