Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
what is the correct answer? A or D?
Thanks
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.
@Giada90 My understanding of this is that by design RLS shows the least restrictive when a person is in multiple roles. What this means is if a person is in 2 roles, it will show the combination of both of those roles. So, I'm going with A.
@Giada90 My understanding of this is that by design RLS shows the least restrictive when a person is in multiple roles. What this means is if a person is in 2 roles, it will show the combination of both of those roles. So, I'm going with A.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |