If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City.

There is a one-to-many relationship between Date and Orders and between City and Orders.

The model contains two row-level security (RLS) roles named Role1 and Role2.

Role1 contains the following filter.

City [State Province] = "Kentucky"

Role2 contains the following filter.

Date [Calendar Year] = 2020

If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?
A . The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.
B . The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.
C . The user will see only data for which the State Province value is Kentucky.
D . The user will receive an error and will not be able to see the data in the report.

View Answer

Answer: B

Explanation:

When a report user is assigned to multiple roles, RLS filters become additive. It means report users can see table rows that represent the union of those filters.

Reference: https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance