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 (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.
RE: Improve Direct Query Date Time Handling
Yeah.
I am using weird alternative for this.
It would be nice to see that feature added.
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.
RE: Improve Direct Query Date Time Handling
I completely agree and second that DQ needs to support Date Hierarchy
RE: Improve Direct Query Date Time Handling
Date hierarchy needs to be available in Direct Query mode in addition to Import mode.