Forum Discussion
Date Table in Warehouse (Time Intelligence)
Hi plimbacher The dashed blue line signifies that the table is in "DirectLake" mode (data is not Imported into the Semantic model but is accessed very fast in the underlying storage layer). Marking a table as a date table is currently not supported if you are using the "default semantic model". You'll need to create a custom semantic model and then the option becomes available:
Learn about Direct Lake in Power BI and Microsoft Fabric - Microsoft Fabric | Microsoft Learn
-------------------------------------------------------
If my reply has been useful please consider
providing kudos (thumbs up) and/or marking
the reply as the solution
-------------------------------------------------------
Hi plimbacher ,
I agree with AndyDDC ‘s answer, I've seen other people in the community encounter situations where the “Mark as date table” option is not available and that's how I solved it.
Solved: Re: Mark as Date table - Microsoft Fabric Community
In addition to what AndyDDC mentioned, there are a couple of additional points.
If you are in a custom semantic model where the “Mark as date table” option is not available, you can check if the “date” field in the table is formatted correctly as “date” or “date/time” data type. The format should be “date” or “date/time” data type.
Check to see if there are any active relationships between the date table and other tables in the model. If there is no relationship, you may not be allowed to mark it as a date table.
Ensure that there are no duplicate dates in the date table and that each date only appears once.
If you have any further questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!