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

Oh. I also see that the "Storage mode" for my table is set to "DirectQuery", which looks like that will prevent auto-creation of date hierarchies. I also don't see a way to change that value for my table, as the dropdown is greyed out.

Is there no way to use this feature with a datamart then?