Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: D. [Email Address] = USERPRINCIPALNAME() * Explanation: - Since the table has an Email Address column, the correct filter is to match that column with USERPRINCIPALNAME(). - USERPRINCIPALNAME() returns the user’s login in email format (e.g., [email protected] ), which is consistent across both Desktop and Service. * Why not the others: A. [Email Address] - USERNAME() → Wrong operator (- instead of =). B. [Employee Name] - USERPRINCIPALNAME() → Wrong column; names don’t match login IDs. C. [Employee Name] = USERNAME() → Wrong column and inconsistent format between Desktop and Service.
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