Forum Discussion

dmatliak's avatar
dmatliak
Frequent Visitor
4 years ago
Solved

Incorrect date format when importing data from Power BI dataset

I have a problem with format of my Date field. The field is recognized as date field, it shows values chronologically, but I can not use the date field as hierarchies. The date value is showed in for...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi dmatliak ,

     

    The date hierarchy will work for you when the below conditions are met:

    • 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

    For more details, please kindly refer to the blog:

    Why there is no date hierarchy - Microsoft Power BI Community

     

     

    When you connect to Power BI datasets, the default mode is Live connection, which prohibits changing the data type/data format/ create custom hierarchy.

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi dmatliak ,

 

The date hierarchy will work for you when the below conditions are met:

  • 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

For more details, please kindly refer to the blog:

Why there is no date hierarchy - Microsoft Power BI Community

 

 

When you connect to Power BI datasets, the default mode is Live connection, which prohibits changing the data type/data format/ create custom hierarchy.

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.