Analyzing and Visualizing Data with Microsoft Power BI — Question 7

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

Answer options

• A. Add the following filters to a report. CountryRegionName is United States ProductCategory is Clothing
• B. From Power BI Desktop, create a new role that has the following filters. [CountryRegionName] = "United States" [ProductCategory] = "Clothing"
• C. Add the following filters in Query Editor. CountryRegionName is United States ProductCategory is Clothing
• D. From Power BI Desktop, create a new role that has the following filter. [CountryRegionName] = "United States" && [ProductCategory] = "Clothing"

Correct answer: A

Explanation

The correct answer is A because applying filters directly to a report allows the sales team to view only the relevant data without needing to manage roles. Options B and D involve creating roles, which is unnecessary for this requirement. Option C suggests using Query Editor, which is not suitable for restricting data visibility in reports.