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.

Anonymous's avatar
Anonymous
Not applicable
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

    Thanks for confirming this. I was able to just add an additional column to my dataset manually to get the date I was hoping for here. It's unfortunate there isn't a way to support this via a live connection, but I'm sure it's for a reasonable reason.