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

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define a role that filters data by region.

Power BI

FILTER('Sales', 'Sales'[Region] = [1])

Drag options to blanks, or click blank then click option'

A'North'

B'South'

C'East'

D'West'

Attempts:

3 left

💡 Hint

Common Mistakes

Using a region name without quotes

Using a column name instead of a value

The filter expression uses the region 'South' to restrict data visible to that role.

2fill in blank

medium

Complete the DAX expression to create a dynamic filter for the current user.

Power BI

FILTER('Employees', 'Employees'[UserName] = USERPRINCIPALNAME() && 'Employees'[Department] = [1])

Drag options to blanks, or click blank then click option'

A'Marketing'

B'HR'

C'Finance'

D'IT'

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting quotes around the department

Using a wrong department name

This filter restricts data to employees in the Finance department matching the current user.

3fill in blank

hard

Fix the error in the RLS filter expression to correctly restrict data by country.

Power BI

FILTER('Orders', 'Orders'[Country] = [1])

Drag options to blanks, or click blank then click option'

A'USA'

BUSA

C"USA"

DOrders[Country]

Attempts:

3 left

💡 Hint

Common Mistakes

Using unquoted text

Using double quotes instead of single quotes

The country name must be a text string enclosed in single quotes for the filter to work.

4fill in blank

hard

Fill both blanks to create a role that filters sales by region and year.

Power BI

FILTER('Sales', 'Sales'[Region] = [1] && 'Sales'[Year] = [2])

Drag options to blanks, or click blank then click option'

A'East'

B'West'

C2023

D2022

Attempts:

3 left

💡 Hint

Common Mistakes

Putting year in quotes

Using wrong region name

The filter restricts data to the East region and the year 2022.

5fill in blank

hard

Fill all three blanks to create a DAX filter that restricts data by user, department, and active status.

Power BI

FILTER('Employees', 'Employees'[UserName] = USERPRINCIPALNAME() && 'Employees'[Department] = [1] && 'Employees'[IsActive] = [2] && 'Employees'[Role] = [3])

Drag options to blanks, or click blank then click option'

A'Sales'

BTRUE()

C'Manager'

DFALSE()

Attempts:

3 left

💡 Hint

Common Mistakes

Using FALSE() instead of TRUE()

Omitting quotes around text values

This filter allows only active Sales department managers matching the current user.