Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
6 months ago
Solved

RLS with multitenancy

 

in case of multi tenancy, should we have different semantic models for each instance (US and EU regions) or we should keep single semantic model and apply RLS or filter on that semantic model? also , in which scenario, the cost would be less?

  • Hii powerbiexpert22 

     

    For most multitenant scenarios, a single semantic model with RLS is the best approach because it minimizes cost, simplifies maintenance, and ensures consistent logic across tenants. Separate semantic models (for US/EU) are only recommended when there are strict data-residency, compliance, or performance isolation requirements. From a cost perspective, one shared model with RLS is always cheaper than maintaining multiple regional models or capacities.

3 Replies

  • Hii powerbiexpert22 

     

    For most multitenant scenarios, a single semantic model with RLS is the best approach because it minimizes cost, simplifies maintenance, and ensures consistent logic across tenants. Separate semantic models (for US/EU) are only recommended when there are strict data-residency, compliance, or performance isolation requirements. From a cost perspective, one shared model with RLS is always cheaper than maintaining multiple regional models or capacities.

    • v-menakakota's avatar
      v-menakakota
      Community Support

      Hi powerbiexpert22 ,

      Thanks for reaching out to the Microsoft fabric community forum. 

       

      I would also take a moment to thank rohit1991   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

       

       

      Best Regards, 
      Community Support Team 

      • v-menakakota's avatar
        v-menakakota
        Community Support

        Hi powerbiexpert22 ,

        I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

         

        Best Regards, 
        Community Support Team