Forum Discussion
Power BI Usage Metrics Report - UserNames
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.
ThanksHarish KM
Please accept this as a solution if this solves your problem and give kudos as well.
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:)
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!
Sorry this goes beyond my knowledge. Here at my place it's handled by IT platform team.
