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? als...
  • rohit1991's avatar
    6 months ago

    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.