Microsoft Power BI Data Analyst — Question 103

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?

Answer options

• A. The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020.
• B. The user will receive an error and will not be able to see the data in the report.
• C. The user will only see data for which the State Province value is Kentucky.
• D. The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020.

Correct answer: A

Explanation

The correct answer is A because when a user is part of multiple RLS roles in Power BI, the filters applied are combined with an OR logic. Thus, the user will see data where either the State Province is Kentucky or the Calendar Year is 2020. Options B, C, and D are incorrect as they do not reflect the combined filtering behavior of the RLS roles.