What should you do from Power BI Desktop?

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"

microsoft-exams

One thought on “What should you do from Power BI Desktop?

  1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.