Forum Discussion

Manoshi's avatar
Manoshi
Frequent Visitor
1 year ago
Solved

Best Practice for Building and Sharing Semantic Models in Microsoft Fabric

Hi everyone, I’m looking for guidance on best practices for designing my architecture in Microsoft Fabric. My main goal is to create a semantic model using Fabric Warehouse data, build reports on to...
microsoft fabric
power bi
  • wardy912's avatar
    wardy912
    1 year ago

    Hi Manoshi , use onelake security for your RLS/CLS requirements. That way, you are applying the restrictions at the table level, and the restrictions will follow the data in any platform it is used, rather than being specific to the semantic model.

Murtaza_Ghafoor's avatar
Murtaza_Ghafoor
Icon for Super User rankSuper User
1 year ago

Best Practices Summary
Use DirectLake for Fabric data sources.
Maintain one unified semantic model.
Share the model using Build permissions.
Separate data and report workspaces.
Certify the model for team-wide reuse.
Avoid chained semantic models (one model feeding another).
Avoid unnecessary refresh cycles — DirectLake syncs automatically.