Direct Query to Semantic Model missing Date Hierarchy field after creating a duplicate table.

[AdamWhittaker]

So I added a direct query data source and it contains a date table... I then created a table that basically said Date Master = 'Date Table'.

The table seems to work fine and all fields are there apart from the Date Hierarchy field... The original table shows that field. It is also not the data type, the field is named explicitly for that and it is completely missing. Any idea why?

Thanks

[danextian · Accepted solution]

Hi @AdamWhittaker 

It appears that not being able to use date hierarchy is one of the modeling limitations of using Direct Query

DirectQuery in Power BI 

[SreeniBattula]

Normally the date column in semantic model table has date hierarchy the duplicate table also shows the same .

[SreeniBattula]

Please find the example in the below screenshot.

[SreeniBattula]

Please duplicate the table in Power Query editor instead of creating duplicate table using DAX

[AdamWhittaker]

Hi, not sure how to do that in Power Query since its a dynamic pull from a Semantic Model, the table does not show in power query like the others. Thanks