Connect Azure AD to Power BI

[SBX]

Hi,

How can import AAD user data (name, location, title) into Power BI?

Thanks,

S

[Anonymous]

Hi @SBX ,

Based on the information, try using PowerShell Cmdlets to import information to Power bi.

You can view the following links to learn more information.

Solved: Azure AD import to Power BI - Microsoft Fabric Community

Import Azure Active Directory Users into Power BI; An Step toward Dynamic Row-Level Security - RADAC...

Solved: active directory user information import to Power ... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SBX]

Thanks, not the solution I was looking for.  I've used Active Directory instead of Azure Active Directory. It's been a challenge identifying the fields, but I've now got what I needed.

Thanks for your help

[SBX]

1) Microsoft Graph API is discontinued 

2) AAD is not available on PBI, but AD is available. The only issue is that the table structure is very difficult to navigate.

[girishthimmaiah]

Dear 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.