Date column defaulting with hierarchy on import

[jgndc]

When i import my data, the Date column auto-created a Date Hierarchy (i.e. subset) and there is not option to delete it.  I think it's preventing me from creating a one-to-many relationship with my Date Table but i'm not sure.  Any way, can some tell me how to delete this hierarchy.  thanks

[Greg_Deckler · Accepted solution]

I think what you want to do is go into the Preview Features and turn off showing the data as a hierarchy.

[jgndc]

Thank you very much.  i unchecked the Time Intelligence box in the Options menu and it removed the hierarchy.  

[v-piga-msft · Accepted solution]

Hi @jgndc,

By my test, you could try to close the Time intelligence with the steps below to disable the hierarchy.

1. Go to File——Option and settings——Option

2. Data load——untick the Time intelligence

Best Regards,

Cherry 

[MDKCLIRResearch]

This did not work at all for me.

[Greg_Deckler · Accepted solution]

I think what you want to do is go into the Preview Features and turn off showing the data as a hierarchy.