1 semantic model for 2 reports

[jma-consult]

Hello,

We created a semantic model on Power BI Server that is used across multiple reports.

The problem is that we have different RLS to manage per report.

For the same user, for the report 1, he has a geographic RLS, for example,

and for report 2, he has a domain or company structure RLS.

Is it possible to manage different RLSs per report for the same user on a single semantic model?

I've tried various methods without success.

If anyone has a solution other than multiplying the semantic models,

Thank you for your help.

[v-prasare]

Hi @jma-consult ,

This is a limitation of Power BI’s RLS design when a single semantic model is reused across multiple reports.RLS roles are defined at the semantic model level, not at the report level. That’s why you’re running into the problem: the same user can’t have two different security contexts depending on which report they open, if both reports are bound to the same dataset. RLS is evaluated by the dataset engine.

I’d encourage you to submit your detailed feedback and ideas via Microsoft's official feedback channels, such as the Microsoft Fabric Ideas.

Feedback submitted here is often reviewed by the product teams and can lead to meaningful improvement.

thanks,

Prashanth

Ms Fabric community support

[v-prasare]

Hi @jma-consult,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Thanks,
Prashanth Are

[jma-consult]

HI,

When I connect my reports to the Power BI data model, it's impossible to add data to differentiate the reports.
In the Power BI semantic model, there are data, measures, and RLS.
So I can't find a solution.

[R1k91]

if understand correctly you're live connected to a model (SSAS, AAS, Power BI?) and you publish reports on PBIRS.

you could consider to switch from live to import, in this way you're building separate models per each report and each of them can have itsown RLS but you're basically loosing the benefits of a centralized model.

[jma-consult]

Hi,

When I connect my PBI reports to the Power BI data model, it's impossible to add data to differentiate the reports.
In the Power BI semantic model, there are data, measures, and RLS.
So I can't find a solution.

[Greg_Deckler]

@jma-consult One method might be to make a duplicate of the table you are using for RLS with different rules on each and then use the correct table in each report. Kind of wonky but might work. Would heavily depend on the details of what you are trying to do though.