Power BI Usage Metrics Report - UserNames

[RichFlorida]

Hello All,

I'm creating my own Usage Metrics Report by connecting to the PBI Semantic Model that was created for my workspace.

Currently, the Usage Metrics Report identifies users by userid only (users email). Is there a way to add the actual user's First & Last name to the report?

Any ideas are apreciated. 

[v-karpurapud]

Hi @RichFlorida 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

[v-karpurapud]

Hi @RichFlorida 

We have not yet heard back from you about whether the response addressed your query. If it did not, please share more details so we can assist you more effectively.

Thank You.

[HarishKM · Accepted solution]

@RichFlorida  Hey ,
You can use following steps.

STep 1 - Try using azure active directory(AAD) data's graph api to user data like first name ,last name and email id

step 2 - check with your data team if they have any employee table in sql or cloud data base so you can use it power bi desktop and join it based on email/userID to get required data

or  You can create a table viz in power bi and the export your data in excel and now you can extract first name and last name from the same excel file in power bi desktop.

Thanks

Harish KM

Please accept this as a solution if this solves your problem and give kudos as well.

[v-karpurapud]

Hi @RichFlorida 

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @burakkaragoz and @MasonMA  for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solution? This will help other community members solve similar problems faster.

Thank you.

[MasonMA]

Hi @RichFlorida, 

Azure Portal or Microsoft Entra Admin Center can be used to export users with their first name, last name, and email.

Here's a step by step guidance from Microsoft. Download a list of users in the Azure portal - Microsoft Entra ID | Microsoft Learn. 

Your IT/Admin team would know this:) 

[RichFlorida]

Thank you @MasonMA for your reply.

This is very helpful.

Do you know if there is a way to query Entra ID directly from PowerBI, so I can have live updated data?

Thanks!

[MasonMA]

Sorry this goes beyond my knowledge. Here at my place it's handled by IT platform team. 

[RichFlorida]

Thank you @burakkaragoz for your reply.

I'm trying to go with option-1

Do you know how I can make a call to our AD and get a list of users and their emails?

[burakkaragoz]

Hi @RichFlorida ,

Great initiative on building your own Usage Metrics Report! You're correct that by default, Power BI usage metrics only expose the User Principal Name (UPN)—typically the user's email address.

Can You Add First & Last Names?

Unfortunately, Power BI does not natively expose full user profile details (like first and last names) in the usage metrics dataset due to privacy and security considerations.

Workaround Options:

1. Join with an External User Directory:

   • If you have access to a user directory (e.g., from Azure AD or an HR system), you can create a mapping table of UserID (email) to First Name and Last Name.
   • Import this table into your report and create a relationship with the UserID field in the usage metrics model.

2. Use Microsoft Graph API (Advanced):

   • If you're comfortable with scripting, you can use the Microsoft Graph API to fetch user profile details.
   • This requires admin consent and appropriate permissions.

3. Manual Mapping (for Small Teams):

   • For smaller workspaces, you could manually create a table in Power BI with user emails and names.

For more on usage metrics, check out:
Microsoft Learn 

Let me know if you'd like help setting up the mapping table or using Graph API!

---

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was assisted by AI for translation and formatting purposes.