Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A data analyst is designing a Power BI report for executive leadership. The report contains sensitive financial data, and different levels of leadership should only see data relevant to their respective departments or regions. The analyst needs to implement a security model that filters the data at the row level based on the user's login credentials. Which Power BI feature enables this requirement?
- ARow-Level Security (RLS)
- BObject-Level Security (OLS)
- CPower BI Premium Capacity
- DDynamic Filtering
Show answer & explanationAnswer & explanation
Correct answer: A. Row-Level Security (RLS)
Row-Level Security (RLS) in Power BI allows you to restrict data access for given users. Filters restrict data at the row level, and you can define filters within roles. This ensures that users only see the data they are authorized to see, based on their credentials.
Why the other options are wrong
- B. Object-Level Security (OLS) restricts access to specific tables or columns, not individual rows of data.
- C. Power BI Premium Capacity provides enhanced performance and features but does not directly implement row-level data access control; RLS is a separate feature available in Pro and Premium.
- D. Dynamic Filtering refers to interactive filtering within the report by users, not a security mechanism to restrict underlying data access.
Row-Level Security (RLS)
A Power BI feature that restricts data access at the row level based on user roles and filters. Users only see the subset of data they are authorized for.
- Filters data based on user identity.
- Implemented by defining roles and DAX filter expressions.
- Managed in Power BI Desktop and enforced in Power BI Service.
Memory trick: Secure your rows, secure your columns, data access is never solemn.