Date Hierarchy Import

[jgndc]

When i import my data, the Date column auto-creates a Date Hierarchy (i.e. a subset of the field).  I don't know how to remove the hierarchy and think it's preventing me from making a one-to-many relationship with my Date Table.  Not sure that's true or not.  There is no option to remove or delete the hierarchy.  please help!  thanks

[MFelix · Accepted solution]

Hi @jgndc,

This as to do with the options of PBI that by default is considering the automatic hierarchy on date fields this can be turn off on:

File -> Options and Settings -> Data Load -> Time Intelligence [Auto Date/Time]

However this is a virtual Hierrchy and this doesn't prevent you from making the one to many with any table.

What is the error you are getting when creating the realtionship?

Regards,

MFelix

[WolfBiber]

Hi,

you can archieve this making your own Date Table:

Navigate to Data, select your own Date Table and mark this table as "Mark as Date Table"

Be aware that this option is only available if you have a column in this table with Data Type "Date"

Hope this helps you.