Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

PowerBIIdeas

Improve Direct Query Date Time Handling

Submitted by on ‎06-14-2016 02:06 PM
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: Needs Votes
See more ideas labeled with:
78 Comments (78 New)
Comments
justinb0308
New Member
‎07-05-2020 04:23 PM
Please fix this soon.
curran_davis
New Member
‎07-05-2020 04:29 PM
Auto creating the hierarchy would be nice too.
tfeucht
New Member
‎07-05-2020 04:34 PM
Auto hierarchy would be a huge benefit.
syasinwork
New Member
‎07-05-2020 04:36 PM
Please add DATE HIERARCHY in Direct Query mode. This is crucial for me.
cison
New Member
‎07-05-2020 04:36 PM
Agree, please fix this soon or I will be forced to use tableau 😞
tstrader
New Member
‎07-05-2020 04:38 PM
Definitely agree
jaap7
New Member
‎07-05-2020 04:38 PM
Please add Date Hierarchy to DQ.
vspence
New Member
‎07-05-2020 04:39 PM
Please add Date Hierarchy to DQ.
francisco_ruiz
New Member
‎07-05-2020 04:40 PM
Totally agree with this. This feature is much needed. Please fix it soon!
ricardo26
New Member
‎07-05-2020 04:41 PM
This is very useful tool and not having it on direct query is making reports very hard to develop. Please correct this problem ASAP. RL 2/15/2019