Date hierarchy using direct query should have been available from beginning considering how most database data is reported. You shouldn't have to rely on a voting system, waiting for others to realize that this is a big problem.
I can't believe this functionality is not natively available. The work around of creating new columns and using DAX time functions is laborious to say the least! PLEASE MAKE THIS FEATURE!
Another comment - because this really needs to be done.
Please take a look on this - causes so much re work!
Also critical: hierarchy dates for charts!
must need option
Please look into this ASAP.
Please add this! Agree wholeheartedly that Direct Query & Import modes should have the same date handling functionality!!!
Please add DATE HIERARCHY in Direct Query mode also. Why there is such a difference in import and direct query mode. Too much difficulty in handling such situation.
I do not understand why direct query acts differently than import. This needs to be fixed. I am spending silly amounts of time trying to work around it.