Date hierarchy not applied on specific table

[LuukMontfoort]

Hi All,

Today I ran in to a strange issue unfortunately I can not resolve, maybe one of you has the fix?

We have a datawarehouse (DW) provided by our application supplier and we connected Power BI via SQL Server Connection to that DW. There we have a few tables (this is not everything) that are shown below. The create_Time table is a Date/Time table just as the due_time table is.

Unfortunately Power BI does not mark the create_time table as a Date/Time table in the view on the right when you create visuals as the due_time table does. This makes it harder to filter on date/time as an hierarchy. 

We have tried to set the table as date table, then we get the following error.

Does anyone know how to fix this? Many thanks in advance!

Luuk

[LuukMontfoort]

Hi Miguel,

Thanks for the response, this indeed has fixed the issues we have.

Enjoy your day!

[MFelix · Accepted solution]

Hi @LuukMontfoort ,

In Power BI you need to create a Date table and a time table as dimensions and on the facts you also need to split the date from time and make the relationships base on those two columns, that way you are abble to do a functional model.

https://radacad.com/how-to-use-time-and-date-dimensions-in-a-power-bi-model