Static RLS rules in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

DAX Measure Result with Static RLS

Given a table 'Sales' with columns 'Region' and 'Amount', and a static RLS rule that filters 'Region' to 'West', what is the result of the following measure?

Total Sales = SUM(Sales[Amount])

If the 'Sales' table contains:
- West: 100, 200
- East: 300, 400

What is the output of Total Sales when the RLS is applied?

A 300

B 1000

C 700

D 0

💡 Hint

Remember that static RLS filters the data before the measure calculation.

Static RLS filters the 'Sales' table to only include rows where Region = 'West'. The amounts for West are 100 and 200, so the sum is 300.

❓ visualization

intermediate

Visual Impact of Static RLS on a Bar Chart

You have a bar chart showing total sales by region. A static RLS rule restricts data to the 'North' region only.

Which of the following describes the correct visual output?

A The bar chart shows bars for all regions, but only 'North' has a value; others show zero.

B The bar chart is empty with no bars displayed.

C The bar chart shows all regions with their original sales values.

D The bar chart shows bars only for the 'North' region; other regions are not displayed.

💡 Hint

Static RLS filters the data source, so only allowed data is visible in visuals.

Static RLS filters the data before visuals are rendered. Only 'North' region data is available, so only that bar appears.

🧠 Conceptual

advanced

Understanding Static RLS Rule Application

Which statement best describes how static RLS rules are applied in Power BI?

A Static RLS filters data at the data source level before loading into Power BI.

B Static RLS allows users to edit the filter rules directly in the report view.

C Static RLS applies a fixed filter on tables inside Power BI that does not change per user.

D Static RLS filters data dynamically based on user login at query time within Power BI.

💡 Hint

Think about what 'static' means in this context.

Static RLS applies fixed filters defined in Power BI Desktop or service that does not vary by user identity.

❓ data_modeling

advanced

Modeling Static RLS with Role Filters

You want to create a static RLS role that restricts users to see only data where 'Country' = 'USA'. Which of the following DAX filter expressions correctly implements this static RLS rule on the 'Customers' table?

A FILTER(Customers, Customers[Country] = "USA")

B Customers[Country] = "USA"

C Customers[Country] IN {"USA"}

D Customers[Country] <> "USA"

💡 Hint

Static RLS roles use simple filter expressions on columns.

The RLS role filter expression should be a boolean condition on the column, like Customers[Country] = "USA".

🔧 Formula Fix

expert

Debugging Static RLS Not Applying Correctly

A report uses a static RLS role filtering 'Region' = 'South'. However, users assigned to this role see data from all regions.

Which of the following is the most likely cause?

A The RLS role was created but not assigned to any users.

B The filter expression uses incorrect column name 'Regions' instead of 'Region'.

C The report uses DirectQuery mode which disables RLS.

D The measure used ignores filters and uses ALL() function.

💡 Hint

Check role assignments carefully.

If users are not assigned to the RLS role, the filter does not apply and they see all data.