Forum Discussion
Super UserHow 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
Super UserHi jaryszek ,
Thank you for reaching out to the Microsoft Fabric Forum Community.
Since the question is on dividing the data into multiple semantic models.you can do that in 2 steps.
- step1 create a fabric notebook-in this step we will load the parquet data into dataframe using abfs path or relative path.then you can apply different filters to it and create multiple tables based on your requirements.once the tables are created save every table as a lakehouse table.
- step 2 go to powerbi desktop,select get data and lakehouse connector after that select the tables you want in your model.once loaded publish them.(this is one time activity post that your models will be ready and you can schedule refresh).
This is how you can solve your issue.
for relationship issue avoid giving same names to the matching columns to create relationships automatically(for example,if one table has empid,name other column as id.power bi will auto create relationships if column names are same).
- jaryszek
Ok what if i have 1 semantic model and want to change different date granularity?
How to model star schema to achive it?
And multiple semantic models --> i do not know if this is the best option to show different granularities based on the same report.- Praful_Potphode
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
