You manage a Power BI model has a table named Sales. You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing. What should you do from Power BI Desktop?
A.
From Power BI Desktop, create a new role that has the following filter. [countryRegionName]= "United States" && [ProductCategory]= "Clothing"
B.
Add the following filters in Query Editor. CountryRegionName is United States ProductCategory is Clothing
C.
From Power BI Desktop, create a new role that has the following filters. [CountryRegionName]= "United States"
D.
Add the following filters to a report. CountryRegionName is United Sates
Correct answer is:
[CountryRegionName] = "United States"
[ProductCategory] = "Clothing"
First, You have 2 tables (Sales & Products), Second, You have to use RLS to prevent a sales team to view some data, Third, You have to create 2 filters, one for Sales(CountryRegionName) & one for Product(ProductCategory) as there are 2 different tables, so there are 2 filters NOT just one filter.
Note: you can't filter 2 columns from 2 DIFFERENT TABLES using && but you can use && in case of the columns you wanna filter in the SAME TABLE only.
The answer in this question is incomplete.
Assuming that others Outside the United States and Clothing are viewing this data, B won't work because you have to go in and keep changing it when you give it to Users who need to see other data "Outside" of United States and Clothing. Using an RLS helps because you can do all the changes you need in the report knowing that the right users can only see what they are meant to see....Filtering it specifically and locking the dataset so that the report only shows United States and Clothing is not best practice because you have to do it for EVERYONE which is admin intensive because you have to go in and change the filters everytime you have it to another Sales Team. Mind you, the example doesn't give a context of who are my Users, how many they are ,what the data looks like and is there any other Categories I should be aware... it's a badly written question tba. But I don't agree with D because the requirement states for United States and Clothing...and if you filtering with only just United States then obviously the Clothing bit is not applied... admin please confirm...
I believe the answer is A, table name is sales, the logic says that sales table will be consumed by sales team and no other teams, so no need to create a role in this case as sales team are the only people who will see the dashboard, so it is enough to fiter the dashboard on these values (assuming that D is missed compared to previous question in this series
A is the correct answer
You have to use RLS (Row-level Security) to prevent some users to see some data, so you have to make a new role for that sales team
Here, the data is in one table names Sales so you can add && between the filters in the role
You can apply a filter on report-level and lock it, so option D can be the right option:
https://community.powerbi.com/t5/Desktop/How-to-lock-filters-so-that-end-users-cannot-change-them/td-p/577736
However this answer misses the Productcategory "clothing"...
I don't see why changing the query filters would not be the best solution though.
The question #10 in Topic 1 is similar, and complete answer is "Add the following filters to a report. CountryRegionName is United States ProductCategory is Clothing" it is similar answer here is D, only missing the ProductCategory is Clothing.
I agree because B represents both criteria - Product Category and CountryRegion as well.
Above this a filter may be locked, so a role must not be the solution.
To me it's the most complete approach.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Dik
Highly Voted 5 years, 10 months agosjonghe
4 years, 1 month agoLhouss
4 years agoGeDei
Highly Voted 4 years, 8 months agoMabuse1
1 year, 4 months agoLhouss
Most Recent 4 years agoLhouss
4 years agoCDL
4 years, 1 month agoborut
4 years, 4 months agov__
4 years, 3 months agoMabuse1
1 year, 4 months agoEchicken69
4 years, 5 months agoKristiannl
4 years, 6 months agoAgustin
4 years, 6 months agomaqk1985
4 years, 10 months agomohroshdy
4 years, 11 months agoDirk
4 years, 9 months agoCYRUSD
4 years, 7 months agovcyc
4 years, 5 months agotwane
5 years, 3 months agoHien
5 years, 3 months agoHien
5 years, 3 months agoDirk
4 years, 9 months agoDDS
5 years, 3 months agoJohnFan
5 years agosumitmalik
4 years, 6 months agoTiaanR
5 years, 5 months agorohit
5 years, 6 months ago