Forum Discussion
SBX
1 year agoFrequent Visitor
Connect Azure AD to Power BI
Hi, How can import AAD user data (name, location, title) into Power BI? Thanks, S
girishthimmaiah
Resolver I
1 year agoDear S,
There are two ways to bring Azure AD user data (name, location, title) into Power BI:
1. Through Microsoft Graph API (For More Data)
Register an application in Azure AD and give permissions to read user profile details.
Then pull that into Power BI Power Query from this API:
API link: https://graph.microsoft.com/v1.0/users?$select=displayName,jobTitle,officeLocation
Sign in and load the data into Power BI.
2. Azure AD Connect Use (Easy Way, but Limited Data)
Open Power BI and click on Get Data > Azure > Azure Active Directory.
Please log in with your work account.
Select and complete user details such as name, job title, and location.