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
How can this be right ? Shouldn’t we need a role ?
8
0