Forum Discussion

jgndc's avatar
jgndc
New Member
8 years ago
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...
  • MFelix's avatar
    MFelix
    8 years ago

    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

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

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