Date hierarchy doesn't appear when I use a DBMS data source

[Anonymous]

I have some data held in Excel , which , when imported , automatically creates Hierarchies on the date columns. 

When the same dataset is imported from a DB table , the date columns are recognised as such, but no hierarchies are created.

Please assist.   

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
Dates hierarchies also refer to relationships with other tables.

Please refer to the linked blog post of @Anonymous :

https://community.fabric.microsoft.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly