645
S

Improve Direct Query Date Time Handling

Sam Bloggs on 6/14/2016 9:06:14 PM
645
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

Power BI User on 7/5/2020 11:04:20 PM

2018 is coming but it still no yet fix

S

S

RE: Improve Direct Query Date Time Handling

Anon on 7/5/2020 11:00:24 PM

The Date Hierarchy drives all reporting, every customer needs to see performance over time. We need this feature, this limitation is making working with Power BI in direct query mode frustrating! Please add this to the next update.

S

S

RE: Improve Direct Query Date Time Handling

Power BI Ideas Admin on 7/5/2020 10:59:51 PM

plz

S

S

RE: Improve Direct Query Date Time Handling

Power BI User on 7/5/2020 10:57:18 PM

Please add DATE HIERARCHY in Direct Query mode!!!

S

S

RE: Improve Direct Query Date Time Handling

Keith Chan on 7/5/2020 10:50:00 PM

Bump. Hope this makes it into the next update!

S

S

RE: Improve Direct Query Date Time Handling

Jorge Abreu on 7/5/2020 10:45:55 PM

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.

S

S

RE: Improve Direct Query Date Time Handling

Sassine on 7/5/2020 10:45:23 PM

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

S

S

RE: Improve Direct Query Date Time Handling

Power BI User on 7/5/2020 10:41:11 PM

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.

S

S

RE: Improve Direct Query Date Time Handling

Joe Hedrick on 7/5/2020 10:35:09 PM

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

S

S

RE: Improve Direct Query Date Time Handling

Power BI User on 7/5/2020 10:34:18 PM

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