Please add this feature, it would be really handy.
This request is represented twice (https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16835431-automatic-date-hierarchy-for-direct-query-data), and both register a high number of votes. Please consider this in the next prioritization cycle, as this is foundational functionality.
This feature is much needed. Please make it happen!
Totally agree with this
Totally agree with this. I just spent half a day trying to hack a way to do this, only to find it was the direct query killing things.
You're gonna have to add this if you want to claim you support interactive analytics.
Please add DATE HIERARCHY in Direct Query mode. This is crucial for me. Apart from that there is no functionality with creation of quick measure using Time functions (calculate year over year diff and so on)
Directquery Is so límited, it makes it not a viable function.
Date herarchy, tablets, formats.
Please work on this.
This is not functional
So disappointed where date time hierarchy is very crucial for the report. Microsoft PowerBI team has been focusing on the wrong part of enhancement and update! Issue has been floating since 2016 and still cant see the limelight of this.
We do not want fancy features, get the core basics right first! *Furious*
Date hierarchy is very important for the data visualization and without it, the POwer BI is without power.... :(
we need date hierarchy in direct query!!