Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
When a report user is assigned to multiple roles, RLS filters become additive which meas the user can see State Province value is Kentucky or the Calendar Year is 2020.
So the answer is B.
When a report user is assigned to multiple roles, RLS filters become additive which meas the user can see State Province value is Kentucky or the Calendar Year is 2020.
So the answer is B.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.