Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Date hierarchies aren't working in DirectQuery Mode, but are working in Import mode. Please help
Import Mode
DirectQuery Mode
Searching around, I think below is the best response. Turning on Date/Time Table does NOT fix this in DirectQuery Mode. You will need to request the Model owner to add a Date Table (and name the bloody fields appropriately so users KNOW the date table pllies to Column X, so don't call it Date Table, call it "Purchased Date Table"!)
@Anonymous ,there can be a few reasons.
You might have switched off auto date time at file level (In options and Setting -> Options )
Joined these dates with a date table
These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045
Check Settings
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time
I always prefer a date table and not the auto date time hierarchy
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |