Discover whether adding user objects to the list of synced objects in Microsoft Entra Connect will ensure measures using the USERNAME() function return the UPN of users when querying a semantic model with dynamic RLS in Microsoft Fabric.
Table of Contents
Question
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
Your network contains an on-premises Active Directory Domain Services (AD DS) domain named contoso.com that syncs with a Microsoft Entra tenant by using Microsoft Entra Connect.
You have a Fabric tenant that contains a semantic model.
You enable dynamic row-level security (RLS) for the model and deploy the model to the Fabric service.
You query a measure that includes the USERNAME() function, and the query returns a blank result.
You need to ensure that 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 meet the goal?
A. Yes
B. No
Answer
B. No
Explanation
No, adding user objects to the list of synced objects in Microsoft Entra Connect will not ensure that the measure returns the user principal name (UPN) of a user when querying a semantic model with dynamic row-level security (RLS) enabled in Microsoft Fabric.
Microsoft Entra Connect synchronizes users and groups from an on-premises Active Directory Domain Services (AD DS) domain to a Microsoft Entra tenant. However, simply adding user objects to the sync does not automatically make the USERNAME() function return the UPN in measures.
For the USERNAME() function to return the correct UPN within a measure in a semantic model with dynamic RLS, the model must be configured to use the UPN as the username property. This is typically done by mapping the UPN attribute from the user table or dimension to the Username property in the model.
Syncing the user objects is a prerequisite for accessing the UPN values, but it does not directly impact how the USERNAME() function behaves in the semantic model. The model itself must be set up correctly to utilize the UPN for the USERNAME() function to return the expected values.
Microsoft DP-600 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Microsoft DP-600 exam and earn Microsoft DP-600 certification.