Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsEasy
A data analyst needs to validate that the Row-Level Security (RLS) roles defined in a Power BI Desktop model are working as expected before publishing the report. Which feature within Power BI Desktop allows the analyst to test these roles?
- APerformance Analyzer
- BAnalyze in Excel
- CManage roles
- DView as roles
Show answer & explanationAnswer & explanation
Correct answer: D. View as roles
The 'View as roles' feature in Power BI Desktop allows a developer to simulate how a report will appear to users assigned to specific RLS roles. This is crucial for verifying that RLS rules correctly filter data before deployment.
Why the other options are wrong
- A. Performance Analyzer helps optimize report performance, not test security roles.
- B. Analyze in Excel exports data for analysis in Excel, not for testing RLS within Power BI Desktop.
- C. Manage roles is where RLS roles are defined, but 'View as roles' is for testing them.
Power BI Desktop View as Roles
A Power BI Desktop feature that allows developers to preview a report as if they were a user assigned to a specific Row-Level Security (RLS) role.
- Simulates RLS application.
- Found in the Modeling tab.
- Essential for RLS validation before publishing.
Memory trick: View as roles, see what the user knows.