Date Table in Warehouse (Time Intelligence)

[plimbacher]

I've created Date Table in data warehouse.  I have also created a View.  I cannot mark either as 'Date Table'; that option is greyed out.  The resulting visuals in the report do not recognize the Time Intelligence functionality.  Also, not sure why the blue line at the top of the date table is a broken blue line, not solid.  Is this an indicator that something is incomplete, incorrect, etc.?  

[frithjof_v]

In my opinion, the default semantic model should be removed from Fabric, because it has so many limitations compared to a custom (new) semantic model. The default semantic model also takes up unnecessary space in the workspace.

Please vote for this idea to remove the default semantic model: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b0d89799-fceb-ee11-a73d-000d3a012188

[Anonymous]

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!

[AndyDDC · Accepted solution]

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

-------------------------------------------------------

[plimbacher]

Thanks for the quick response!! (apologies for my delayed response🙄.  I created a new semantic model using the 'Custom' option and was able to marke the Date Table as 'mark as a date table'.  All set!