Why RLS protects sensitive data in Power BI - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

How does Row-Level Security (RLS) restrict data access?

Imagine a sales report where each salesperson should only see their own sales data. How does RLS ensure this?

A RLS filters data at the row level based on user identity, showing only allowed rows.

B RLS encrypts the entire dataset so only authorized users can decrypt it.

C RLS hides columns with sensitive data but shows all rows to everyone.

D RLS duplicates data for each user to separate databases.

💡 Hint

Think about how data visibility changes depending on who is logged in.

RLS works by filtering rows dynamically based on the user's identity, so each user sees only the data they are permitted to view.

🎯 Scenario

intermediate

Scenario: Protecting sensitive employee data with RLS

Your company wants managers to see only their team's salary data, not others'. How can RLS help?

A Duplicate the employee table for each manager with only their team's data.

B Create RLS roles that filter employee rows by manager ID matching the logged-in user.

C Use RLS to hide the salary column for all users except HR.

D Disable RLS and rely on manual report sharing.

💡 Hint

Consider how to filter rows so managers see only their team's data.

By creating RLS roles that filter rows where the manager ID matches the logged-in user, managers see only their team's salary data.

❓ dax_lod_result

advanced

DAX expression effect under RLS

Given this DAX measure:
Total Sales = SUM(Sales[Amount])
and RLS filters Sales by Region for each user, what does Total Sales show?

A Sum of sales for all regions regardless of RLS.

B Sum of sales for regions not visible to the user.

C Sum of sales only for the regions visible to the logged-in user.

D Zero, because RLS blocks all sales data.

💡 Hint

Remember RLS filters data before measures calculate.

RLS filters the Sales table rows before the measure sums amounts, so only visible regions' sales are included.

🔧 Formula Fix

advanced

Why does this RLS filter not work as expected?

RLS rule: [Region] = USERPRINCIPALNAME()
User's email is '[e-mail]', but no data shows. Why?

A The filter syntax is invalid and causes a syntax error.

B USERPRINCIPALNAME() returns the user's email, which matches Region values correctly.

C RLS filters require numeric columns, so text columns cause errors.

D The Region column contains region names, not user emails, so the filter never matches.

💡 Hint

Check if the filter compares compatible values.

The filter compares Region (like 'North') to the user's email, so no rows match and no data shows.

❓ visualization

expert

Designing a dashboard with RLS for multiple user roles

You must create a Power BI dashboard where sales reps see only their sales, managers see their team's sales, and executives see all sales. How should you design RLS roles and visuals?

A Create RLS roles with filters: reps filter by USERNAME(), managers filter by team membership, executives have no filter; use role-based page navigation.

B Create one RLS role filtering all data by region; use slicers to let users pick their view.

C No RLS needed; share separate dashboards manually for each role.

D Use RLS to hide columns instead of rows; show all sales but mask sensitive fields.

💡 Hint

Think about how to apply different filters per role and control access.

Different RLS roles with appropriate filters ensure each user sees only their allowed data. Role-based page navigation can enhance user experience.