Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsEasy
A data analyst needs to ensure that users in different departments can only view sales data relevant to their specific department within a Power BI report. The solution must dynamically filter data based on the user's login. Which feature should the analyst implement?
- APower BI gateway
- BRow-level security (RLS)
- CData sensitivity labels
- DObject-level security (OLS)
Show answer & explanationAnswer & explanation
Correct answer: B. Row-level security (RLS)
Row-level security (RLS) is designed to restrict data access for given users based on filters applied to rows in the underlying data. This directly addresses the requirement for department-specific data viewing.
Why the other options are wrong
- A. A Power BI gateway facilitates on-premises data connectivity but does not manage row-level access.
- C. Data sensitivity labels classify data but do not restrict row-level access.
- D. OLS restricts access to specific columns or tables, not rows.
Row-Level Security (RLS)
RLS in Power BI allows you to restrict data access for specified users. It filters rows in the underlying data model based on defined rules.
- Filters data at the row level.
- Implemented using DAX expressions in Power BI Desktop.
- Manages access based on roles assigned to users.
Memory trick: Rows Restrict, Objects Obscure, Labels Classify.