nerdexam
Microsoft

PL-300 · Question #178

You manage a Power BI model has a table named Sales and product. You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value

The correct answer is C. From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]=. To implement security such that a specific sales team can only view data for 'United States' and 'Clothing', you must create a new Role-Level Security (RLS) role in Power BI Desktop with the specified filters.

Submitted by akirajp· Apr 18, 2026Visualize and analyze the data

Question

You manage a Power BI model has a table named Sales and product. You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing. What should you do from Power BI Desktop?

Options

  • AFrom Power BI Desktop, create a new role that has the following filter.[countryRegionName]=
  • BAdd the following filters in Query Editor.CountryRegionName is United StatesProductCategory is
  • CFrom Power BI Desktop, create a new role that has the following filters.[CountryRegionName]=
  • DAdd the following filters to a report.CountryRegionName is United SatesProductCategory is

How the community answered

(41 responses)
  • A
    7% (3)
  • B
    2% (1)
  • C
    88% (36)
  • D
    2% (1)

Why each option

To implement security such that a specific sales team can only view data for 'United States' and 'Clothing', you must create a new Role-Level Security (RLS) role in Power BI Desktop with the specified filters.

AFrom Power BI Desktop, create a new role that has the following filter.[countryRegionName]=

The filter formula provided is incomplete and syntactically incorrect, making this option invalid even if the intent is RLS.

BAdd the following filters in Query Editor.CountryRegionName is United StatesProductCategory is
CFrom Power BI Desktop, create a new role that has the following filters.[CountryRegionName]=Correct

Role-Level Security (RLS) is the correct mechanism in Power BI to restrict data access for specified users or groups. By creating a new role in Power BI Desktop and defining row filters like `[CountryRegionName]="United States"` AND `[ProductCategory]="Clothing"`, only data matching these conditions will be visible to members assigned to that role.

DAdd the following filters to a report.CountryRegionName is United SatesProductCategory is

Concept tested: Power BI Role-Level Security (RLS) implementation

Source: https://learn.microsoft.com/en-us/power-bi/create-reports/service-admin-rls

Topics

#Report Filters#Data Filtering#Power BI Desktop

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PL-300 Practice