PL-300 · Question #344
You have a Power BI data model that contains a table named Employees. The table has the following columns: - Employee Name - Email Address - Start Date - Job Title You are implementing dynamic…
The correct answer is D. [Email Address] = USERPRINCIPALNAME(). The expression checks the email address of the currently logged-in user against the email address in the Employees table, which should be used as the identifier for each employee. This will ensure that each user can only see their own employee data. The other options may not…
Question
You have a Power BI data model that contains a table named Employees. The table has the following columns:
- Employee Name
- Email Address
- Start Date
- Job Title
You are implementing dynamic row-level security (RLS). You need to create a table filter to meet the following requirements:
- Users must see only their own employee data.
- The DAX expression must work in both Power BI Desktop and the Power
BI service. Which expression should you use?
Options
- A[Employee Name] = USERPRINCIPALNAME()
- B[Email Address] = USERNAME()
- C[Employee Name] = USERNAME()
- D[Email Address] = USERPRINCIPALNAME()
How the community answered
(62 responses)- A18% (11)
- B8% (5)
- C5% (3)
- D69% (43)
Explanation
The expression checks the email address of the currently logged-in user against the email address in the Employees table, which should be used as the identifier for each employee. This will ensure that each user can only see their own employee data. The other options may not work in all cases, as the username and user principal name may not always match the email address used as the identifier. https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#using-the-username-or- userprincipalname-dax-function
Community Discussion
No community discussion yet for this question.