Exam PL-300 topic 2 question 67 discussion

Within Power BI Desktop, username() will return a user in the format of DOMAIN\User and userprincipalname() will return a user in the format of [email protected]. Within the Power BI service, username() and userprincipalname() will both return the user's User Principal Name (UPN). This looks similar to an email address.

username() has the format of DOMAIN\username userprincipalname() always returns the user in the format of their user principal name, like [email protected] We want mail, so userprincipalname() is right

USERNAME() will work for PBI Service but not for PBI Desktop as it would return not UPN (User Principal Name" but DOMAIN\Username therefore we must use the solution using the USERPRINCIPALNAME() returning UPN in both cases

D - [Email Address] = USERPRINCIPALNAME() is the correct one because it always returns the email address

WAS ON THE EXAM 02 03 2024

This was on the exam on 22/2/2024 (:

Easy, for manager role (Each manager must see only the data in the Sales and Human Resources tables for their own country) ROLE: Manager TABLE: Country DAX: [Email] = userprincipalname() Filtering the table COUNTRY for the USERNAME will only allow Manager role to see data in other tables filtered by her/his own country ROLE: CFO TABLE: Human Resources DAX: false() The CFO role will only have 1 restricted (false()) table that is Human resources. The rest is without filters

D is the correct answer.

https://www.youtube.com/watch?v=TGgec9oP8oU this video explains it.

To create dynamic row-level security (RLS) in Power BI that allows users to see only their own employee data, you can create a DAX expression using the USERNAME function. Here's the DAX expression you can use for the table filter: scss Copy code Employees[Email Address] = USERNAME() & "@contoso.com" Assuming that the domain for the email addresses is contoso.com, this expression filters the Employees table to show only the rows where the Email Address column matches the email address of the current user. The USERNAME() function returns the Windows account name of the current user in the format DOMAIN\Username. By concatenating the returned value with "@contoso.com", the DAX expression generates the email address of the current user that matches the email address in the Employees table. Note that to use this DAX expression, you need to configure row-level security in Power BI Desktop or the Power BI service. You can assign roles to users and apply filters based on the DAX expression for each role.

does anaybody have any source for this question?

To implement dynamic row-level security (RLS) on the Employees table, a table filter must be created. The table filter should be based on the user's email address or user principal name (UPN), as these are unique identifiers for each user. The DAX expression [Email Address] = USERPRINCIPALNAME() will filter the Employees table to only show rows where the Email Address column matches the UPN of the current user. This expression works in both Power BI Desktop and the Power BI service, and will ensure that each user only sees their own employee data.

But if we use the USERPRINCIPALNAME() function it returns the user's login name, which may not be the same as their email address. right?

Does someone know why C is not correct?

answer is right