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

Comments (78)

Power BI Ideas Admin on 05 Jul 2020 22:59:51

RE: Improve Direct Query Date Time Handling

plz

Power BI User on 05 Jul 2020 22:57:18

RE: Improve Direct Query Date Time Handling

Please add DATE HIERARCHY in Direct Query mode!!!

Keith Chan on 05 Jul 2020 22:50:00

RE: Improve Direct Query Date Time Handling

Bump. Hope this makes it into the next update!

Jorge Abreu on 05 Jul 2020 22:45:55

RE: Improve Direct Query Date Time Handling

CRUCIAL TO HAVE THIS FEATURE ON !!!
POWER BI IS MOVING TO STREAMING LIVE DATA WHERE DIRECT QUERY IS THE BASE FOUNDATION OF THAT PRINCIPLE. GET LIVE AND UPDATED DATA AS SOON AS YOUR DATABASE CHANGES.
SO HAVING THIS KIND OF LIMITATION ON A BASIC FEATURE IT'S A ANNOYING.

Sassine on 05 Jul 2020 22:45:23

RE: Improve Direct Query Date Time Handling

Yeah.
I am using weird alternative for this.
It would be nice to see that feature added.

Power BI User on 05 Jul 2020 22:41:11

RE: Improve Direct Query Date Time Handling

This is a requirement for working with larger data sets. Having no ability to work on date fields in DQ by using custom field is not a good experience.

Joe Hedrick on 05 Jul 2020 22:35:09

RE: Improve Direct Query Date Time Handling

I completely agree and second that DQ needs to support Date Hierarchy

Power BI User on 05 Jul 2020 22:34:18

RE: Improve Direct Query Date Time Handling

Date hierarchy needs to be available in Direct Query mode in addition to Import mode.