Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsEasy
A data analyst needs to validate that row-level security (RLS) is working as expected for a Power BI report before publishing it to the service. The report is open in Power BI Desktop. Which feature should the analyst use to simulate different user roles and verify data visibility?
- AAnalyze in Excel
- BManage relationships
- CPerformance Analyzer
- DView as roles
Show answer & explanationAnswer & explanation
Correct answer: D. View as roles
The 'View as roles' feature in Power BI Desktop allows the analyst to simulate how the report will appear to users assigned to specific RLS roles, ensuring the filters are applied correctly.
Why the other options are wrong
- A. Analyze in Excel connects to the dataset but doesn't simulate RLS roles within the Power BI Desktop report view.
- B. Manage relationships is for defining table relationships in the data model, unrelated to testing RLS.
- C. Performance Analyzer helps optimize report visuals and DAX queries, not simulate RLS.
Power BI Desktop View as Roles
The 'View as roles' feature in Power BI Desktop enables testing of Row-Level Security (RLS) by simulating how a report appears to users assigned to specific roles.
- Located under the Modeling tab in Power BI Desktop.
- Allows selection of one or more RLS roles to simulate.
- Crucial for validating RLS implementation before publishing.
Memory trick: Roles Reveal Rows.