Question 560
A Power BI team has selected this approach: Define dynamic RLS using the signed-in user mapping and appropriate model relationships. The original business context is: A region manager should only see sales transactions for the territories assigned to their username. Which observed result would best confirm the change worked as intended?
Explanation
Correct Answer
Two managers viewing the same report see only their authorized territory rows. It provides the required observation for the chosen implementation: Define dynamic RLS using the signed-in user mapping and appropriate model relationships. This test addresses the stated business constraint directly.
Incorrect Answers
Consumers can read approved reports but cannot update or delete workspace items. That check would be meaningful for the separate case: A shared workspace gives every user Member privileges even though most should only read published reports. It would not directly verify this scenario's selected implementation: Define dynamic RLS using the signed-in user mapping and appropriate model relationships.
An unauthorized user cannot query the protected salary field through the model. That check would be meaningful for the separate case: A report contains salary columns that viewers should never access, not merely rows from other regions. It would not directly verify this scenario's selected implementation: Define dynamic RLS using the signed-in user mapping and appropriate model relationships.
The employee has access only after an authorized permission grant, with an audit trail. That check would be meaningful for the separate case: An analyst shares a report with a new employee through a link that bypasses normal review workflow. It would not directly verify this scenario's selected implementation: Define dynamic RLS using the signed-in user mapping and appropriate model relationships.