Testing RLS in Desktop in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Row-Level Security (RLS) Behavior in Power BI Desktop

When you define Row-Level Security (RLS) roles in Power BI Desktop and test them using the 'View as Roles' feature, which of the following statements is true?

A The data is filtered exactly as it would be for the selected role when published to the Power BI Service.

B The data is filtered only partially and may show more rows than the actual role would see in the service.

C The 'View as Roles' feature does not filter data; it only highlights rows related to the role.

D RLS roles cannot be tested in Power BI Desktop; testing is only possible after publishing.

💡 Hint

Think about how Power BI Desktop simulates the role's data view before publishing.

Power BI Desktop's 'View as Roles' feature simulates the exact data filtering that the selected RLS role would have when the report is published to the Power BI Service. This allows you to verify RLS behavior locally.

🎯 Scenario

intermediate

Testing Multiple RLS Roles in Power BI Desktop

You have created two RLS roles: 'SalesRegionEast' and 'SalesRegionWest'. You want to test the combined effect of these roles in Power BI Desktop. What happens when you select both roles simultaneously in the 'View as Roles' dialog?

A Data is filtered to show only rows visible to both roles simultaneously (intersection).

B Data is filtered to show rows visible to either 'SalesRegionEast' or 'SalesRegionWest' (union of roles).

C Only the first selected role is applied; the second is ignored.

D Power BI Desktop throws an error because multiple roles cannot be selected together.

💡 Hint

Consider how multiple roles combine their filters in Power BI Desktop.

When multiple roles are selected in 'View as Roles', Power BI Desktop applies the union of their filters, showing all data rows visible to any of the selected roles.

🔧 Formula Fix

advanced

Diagnosing RLS Filter Not Applying in Power BI Desktop

You created an RLS role with a DAX filter on the 'Region' column: [Region] = "East". However, when testing in Power BI Desktop using 'View as Roles', the data is not filtered and all regions are visible. What is the most likely cause?

A Power BI Desktop does not support filtering on text columns in RLS roles.

B The DAX filter syntax is incorrect and causes the filter to be ignored.

C The 'Region' column is not included in the data model's relationships, so the filter does not propagate.

D The 'View as Roles' feature only works after publishing to the Power BI Service.

💡 Hint

Think about how RLS filters propagate through relationships in the data model.

If the column used in the RLS filter is not properly related in the data model, the filter will not affect related tables, causing the data to appear unfiltered in 'View as Roles'.

❓ dax_lod_result

advanced

Evaluating RLS Impact on a DAX Measure in Power BI Desktop

Given a table 'Sales' with columns 'Region' and 'Amount', and an RLS role filtering [Region] = "West", what is the result of the following DAX measure when viewed as that role?

TotalSales = SUM(Sales[Amount])

Assume the data is:

• East: 1000
• West: 2000
• North: 1500

A 0

B 4500

C 1000

D 2000

💡 Hint

Remember that RLS filters the data before the measure calculation.

The RLS role filters the 'Sales' table to only include rows where Region = 'West'. The measure sums only those rows, resulting in 2000.

❓ visualization

expert

Designing a Power BI Desktop Report to Test RLS Effectively

You want to create a Power BI Desktop report page that clearly shows the effect of RLS roles on sales data by region. Which visualization setup best helps you verify RLS filtering when using 'View as Roles'?

A A matrix visual showing 'Region' rows and 'Total Sales' values, with no slicers or filters applied.

B A card visual showing overall total sales without any region breakdown or filters.

C A table visual showing 'Region' and 'Total Sales' with a slicer on 'Region' to manually filter data.

D A clustered bar chart showing 'Region' on the axis and 'Total Sales' as values, with a page-level filter on 'Region'.

💡 Hint

Think about a visualization that automatically reflects RLS filtering without manual user filtering.

A matrix visual listing all regions with their total sales will show only the regions visible to the RLS role when using 'View as Roles'. This makes it easy to verify RLS filtering effects without manual slicers or filters.