Answer-first summary for fast verification
Answer: No
The solution does not meet the goal because USEROBJECTID() returns the Azure Active Directory object ID (a GUID) of the current user, not their user principal name (UPN). The USERNAME() function returns the domain\username format in on-premises AD DS environments, which explains the blank result when synced to Microsoft Entra ID. To return the UPN, the correct function to use is USERPRINCIPALNAME(), which specifically returns the user's UPN format (e.g., user@contoso.com). The community discussion unanimously supports this with 100% agreement on answer B ('No') and detailed comments confirming USERPRINCIPALNAME() is the appropriate function.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have a Fabric semantic model with dynamic row-level security (RLS) enabled. When you query a measure that uses the USERNAME() function, it returns a blank result. You need the measure to return the user principal name (UPN) of the user.
Solution: You update the measure to use the USEROBJECTID() function.
Does this solution meet the goal?
A
Yes
B
No
No comments yet.