PL-300 · Question #30
You have five sales regions. Each region is assigned a single salesperson. You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales…
The correct answer is A. Use the Test as role option to view data as the salesperson's user account. Dynamic RLS filters data based on the signed-in user's identity (typically matched via USERPRINCIPALNAME() or USERNAME() in the DAX filter). To verify exactly what data a specific salesperson sees, you must test using her actual user account - not just the role. In Power BI…
Question
You have five sales regions. Each region is assigned a single salesperson. You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson. Salespeople must see only the data from their region. You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople. A salesperson reports that she believes she should see more data. You need to verify what data the salesperson currently sees. What should you do?
Options
- AUse the Test as role option to view data as the salesperson's user account.
- BUse the Test as role option to view data as the Sales role.
- CInstruct the salesperson to open the report in Microsoft Power Bl Desktop.
- DFilter the data in the reports to match the intended logic in the filter on the sales transaction table.
How the community answered
(23 responses)- A78% (18)
- B13% (3)
- C4% (1)
- D4% (1)
Explanation
Dynamic RLS filters data based on the signed-in user's identity (typically matched via USERPRINCIPALNAME() or USERNAME() in the DAX filter). To verify exactly what data a specific salesperson sees, you must test using her actual user account - not just the role. In Power BI Service, the 'Test as role' option allows you to specify both the role (Sales) AND a specific user account, which replicates the exact filter that salesperson experiences. Testing as only the Sales role (B) without specifying her username would not apply the dynamic per-user filter accurately.
Topics
Community Discussion
No community discussion yet for this question.