How to divide semantic model for specific range of dates from OneLake ?

Hi jaryszek 

Thanks for reaching out again.

in this case we can create self service BI Model with RLS/OLS as mentioned by v-pgoloju.

the data model may look like below:

• there will be one fact table which will have data at day level and another fact table at year/month level(based on your requirement ).
• Date dimension will be connected at day granularity to day fact table
• Date dimension will be connected at year/month granularity to year/month fact table.
• Other dimensions will be connected based on keys.

then you can design RLS/OLS.(in OLS you can create a role who will see day level fact table and another role who will see year/month level fact table)

Thanks & Regards,

Praful Potphode