Answer-first summary for fast verification
Answer: No
The solution does not meet the goal because the USERNAME() function in Power BI returns the username in the format DOMAIN\Username (from Windows authentication) or the user's email address (from Microsoft Entra ID authentication), not necessarily the UPN. To ensure the UPN is returned, the USERPRINCIPALNAME() function should be used instead. Adding user objects to the sync configuration in Microsoft Entra Connect ensures UPNs are available in Microsoft Entra ID, but it does not change the behavior of the USERNAME() function, which may still return a blank if the UPN is not the primary identity used in authentication. The community discussion shows a split, but the higher upvoted comments and technical accuracy support that USERNAME() is not guaranteed to return the UPN, making the solution insufficient.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Your network contains an on-premises Active Directory Domain Services (AD DS) domain named contoso.com that syncs with a Microsoft Entra tenant using Microsoft Entra Connect.
You have a Fabric tenant containing a semantic model. You enable dynamic row-level security (RLS) for the model and deploy it to the Fabric service. When you query a measure that uses the USERNAME() function, it returns a blank result.
You need to ensure the measure returns the user principal name (UPN) of a user.
Solution: You add user objects to the list of synced objects in Microsoft Entra Connect.
Does this solution meet the goal?
A
Yes
B
No