Forum Discussion
Solved
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 rel...
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
Microsoft Employee
Microsoft EmployeeHi,
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.