Forum Discussion

radious-pro's avatar
radious-pro
Frequent Visitor
3 years ago
Solved

Unable to create date hierarchy when using datamart

I had created a dataset directly in PowerBI Desktop. It pulls data from a postgres db, and does some transforms on it, and then that dataset is used in some reports. I re-created the same data us...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi radious-pro ,

     

    According to the information you provided, you are using the DirectQuery mode. Being unable to use the date hierarchy is a known limitation of DirectQuery, which is by design.

     

    We need to be aware here regarding the date hierarchy.

    • 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

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

     

    Best Regards,
    Community Support Team _ Caitlyn

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

radious-pro's avatar
radious-pro
Frequent Visitor
3 years ago

One additional bit of information that may be helpful, is that in my fields list, on the version that is working as expected, all of my `date` fields have the calendar icon next to them. However, on the version that is not working, none of my `date` fields have the calendar icon next to them.