Forum Discussion
Solved
Direct Query to Semantic Model missing Date Hierarchy field after creating a duplicate table.
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 ...
It appears that not being able to use date hierarchy is one of the modeling limitations of using Direct Query
Normally the date column in semantic model table has date hierarchy the duplicate table also shows the same .
Please find the example in the below screenshot.