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.
