One Semantic model VS Multiple Semantic Models

[robertozsr]

Hello everyone,

I have several clients (in the same domain) to which we provide dashboards. While I am realizing all the analytics inside Fabric, a doubt arise. Should 1 model for all clients, and then have row level security, or for each client a semantic model?

the structure is the following:

Source data land into fabric, and are processed using a medallion architecture (bronze, silver and gold). Once reached the gold layer.
There are two level of data: 
   - Data that all clients have (contextual data) (for this is enogh filtering per client id just to have the data for that client)

   - And client specific Data (different business rules, metrics etc)

I was trying to have one semantic model for all clients, but it seems that it add so much complexity, relationship etc
The reason why, we want one semantic model because it seems easier to maintain in terms of measures etc

But I do think it is better having indiviudal semantic models per each client, because I see the gain in easue of use, perfromance (less relationship etc) even if we lose a bit on resuability

Then, we want to create a standard dashboard that will have the same kpis for each client (but with the logic above), and even in that case I do believe to have separate semantic models.

I am a junior, so that is why I am asking, I am sure I will receive help from much more experienced ppl

Thanks.

[ssrithar]

Hi @robertozsr ,

This is a very common design question, and there’s no single “always right” answer — it depends on how similar your clients really are.

If all clients share the same business logic, KPIs, and relationships, then a single semantic model with RLS can work well.

However, in your case you mention client-specific rules, metrics, and calculations. Once that happens, a single model usually becomes very complex: lots of conditional DAX, inactive relationships, heavy RLS, and harder performance tuning.

In practice, a separate semantic model per client is often the better choice:

Simpler DAX and relationships

Better performance (smaller, cleaner models)

Easier testing and troubleshooting

Safer changes (one client’s change doesn’t impact others)

Reusability doesn’t have to be lost — it’s best handled at the Gold layer (shared tables) and via model / DAX templates and naming conventions, rather than forcing everything into one model.

For standard dashboards, you can still reuse the same report layout and KPIs by binding the same report template to each client’s semantic model.

In short:
same logic → one model + RLS
different logic → multiple semantic models

If this post helps, then please appreciate giving a Kudos or accepting as a Solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!