Date hierarchy

[Anonymous]

While using desktop, my model has date hierarchies, which i need. Auto date / time is checked on my settings. However, when i publish my model to the service and use via data hub to build reports against, the hierarchies have disappeared. Is there a way to stop that happening?

Thank you

[Anonymous]

Thank you very much Joe 🙂

[Joe_Barry · Accepted solution]

Hi @Anonymous 

I'm not sure if that is possible. Would you not consider using a Date table instead and creating relationships from the Date Table to your Fact table. You can then create date hierarchies however you wish from year to days.

This opens a whole array of time inetlligence measure possibilities. It will also reduce the size of your dataset drastically, as when you switch off auto time/date, it will reduce the size of the model.

Here are some articles that will help you with Model design

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time

Joe