QuestionQ33

VerifiedImplement and manage semantic models

You have a semantic model named Model1. Model1 contains five tables that all use Import mode. Model1 contains a dynamic row-level security (RLS) role named HR. The HR role filters employee data so that HR managers only see the data of the department to which they are assigned.

You publish Model1 to a Fabric tenant and configure RLS role membership. You share the model and related reports to users.

An HR manager reports that the data they see in a report is incomplete.

What should you do to validate the data seen by the HR Manager?

Explanation

Because the RLS role is dynamic, it filters data using the signed-in user's identity (via USERPRINCIPALNAME() lookups), not just role membership, so simply activating the HR role in isolation does not reproduce what a specific manager sees. Validating the issue requires using "Test as role" together with entering that HR manager's own user/UPN, effectively viewing the report as that specific person so the dynamic filter logic is evaluated exactly as it would be for their real session.

Community Discussion

No comments yet. Be the first to start the discussion!