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"
correct answer is D because we want to restrict single sales team to see values of Country = USA and category = clothing. Not for all users.
So in desktop we create a role and in services we assign this role to sales team in data set security settings and hence restricting data for that particular team. Kindly correct if i am thinking wrong.