PrepAway - Latest Free Exam Questions & Answers

You manage a Power BI model that has two tables named Sales and Product.

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?

A. Add the following filters to a report.

CountryRegionName is United States

ProductCategory is Clothing

B. 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. Create a new role that has the following filter.

[CountryRegionName] = “United States”&&

[ProductCategory] = “Clothing”

References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter

One Comment on “You manage a Power BI model that has two tables named Sales and Product.


Leave a Reply