You have the Power BI model shown in the following exhibit.
 
There are four departments in the Departments table.
You need to ensure that users can see the data of their respective department only.
What should you do?

A. Create a slicer that filters Departments based on DepartmentID.

B. Create a row-level security (RLS) role for each department, and then define the membership of the role.

C. Create a DepartmentID parameter to filter the Departments table.

D. To the ConfidentialData table, add a calculated measure that uses the CURRENTGROUP DAX function.








 

Suggested Answer: B

Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles.
Reference:
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.