The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
It appears that not being able to use date hierarchy is one of the modeling limitations of using Direct Query
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.
Please duplicate the table in Power Query editor instead of creating duplicate table using DAX
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
User | Count |
---|---|
86 | |
84 | |
34 | |
34 | |
33 |
User | Count |
---|---|
94 | |
79 | |
63 | |
55 | |
51 |