Forum Discussion

manah77g's avatar
manah77g
Regular Visitor
2 years ago

Date column issue

Hello experts,  I imported data from the database. there is a column date which is the completion time, the data type is Date/Time in the power query.   when importing data to Power BI, the colu...
Need Help
AmiraBedh's avatar
AmiraBedh
Super User
2 years ago

Is your table related to any other table based on the date column ?

If yes, the many side of the one-to-many relationship will lose the date hierarchy, while one side will retain the hierarchy. https://community.fabric.microsoft.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682

When the below conditions are met, the date hierarchy will work for you

 

  • Enable automatic date and time
  • The table storage mode is Import
  • The column data type is date or date/time
  • The column isn't the "many" side of a model relationship

 

manah77g's avatar
manah77g
Regular Visitor
2 years ago

Hello Amira,

what is the solution if my mode is direct?

it can't import mode because of huge of data.


  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    AmiraBedh and Thejeswar, Thanks for your contribution on this thread.

    Hi manah77g ,

    Based on your description, it seems like there is something wrong with your date column displaying. And AmiraBedh and Thejeswar give corresponding explanations. Could you please elaborate on the specific challenges you are facing with this date column? Additionally, could you share the desired outcome you’re aiming for? Once we have a clear understanding, we can explore potential solutions or alternatives to address your needs. Thank you.

    Best Regards