Answer-first summary for fast verification
Answer: No
The solution does not meet the goal because creating a role in the model alone will not resolve the issue of USERNAME() returning a blank result. The USERNAME() function in Power BI/Fabric returns the username in the format DOMAIN\Username when using Windows authentication, which may not match the user principal name (UPN) format (user@domain.com) required. The community discussion confirms this with 100% consensus on answer B (No) and the comment explains that creating a role won't solve the purpose and suggests using USERPRINCIPALNAME() instead, which directly returns the UPN. To ensure the measure returns the UPN, the correct approach is to modify the DAX expression to use USERPRINCIPALNAME() rather than relying solely on role creation.
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 to ensure the measure returns the user principal name (UPN) of a user.
Solution: You create a role in the model.
Does this solution meet the goal?
A
Yes
B
No
No comments yet.