Forum Discussion
Date Hierarchy Import
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
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
2 Replies
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
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.
