Reply
Highlighted
Frequent Visitor
Posts: 3
Registered: ‎03-17-2018
Accepted Solution

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


Accepted Solutions
Super User
Posts: 1,287
Registered: ‎09-19-2016

Re: Date Hierarchy Import

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]

data_load.gif

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post


All Replies
Member
Posts: 112
Registered: ‎12-04-2017

Re: Date Hierarchy Import

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"Unbenannt.PNG

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

 

Hope this helps you.

Super User
Posts: 1,287
Registered: ‎09-19-2016

Re: Date Hierarchy Import

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]

data_load.gif

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!