Data Source for O365 Users or Azure Active Directory

[patrickabel]

Similar to MS' Azure Active Directory (AAD) Content Pack, I'm working on a custom Power BI Report that's dependant upon figuring out how to retrieve users and custom properties from AAD, or SPO user profiles. Is this possible from Power BI?

When I "get data" I see a connector for on-prem Active Directory, but not Azure Active Directory. Ideally I'd like to retrieve a data-set that includes a row for each user that includes all their custom properties/meta-data.

How can I do this?

[Eric_Zhang]

---

@patrickabel wrote:

Similar to MS' Azure Active Directory (AAD) Content Pack, I'm working on a custom Power BI Report that's dependant upon figuring out how to retrieve users and custom properties from AAD, or SPO user profiles. Is this possible from Power BI?

When I "get data" I see a connector for on-prem Active Directory, but not Azure Active Directory. Ideally I'd like to retrieve a data-set that includes a row for each user that includes all their custom properties/meta-data.

How can I do this?

---

@patrickabel

AFAIK, the only AAD integrated feature in Power BI is Azure Active Directory meets Power BI. If this is not what you need, you may have to retrieve user and custom properties from AAD by yourself via AAD Graph API. See one thread Microsoft Graph API User custom property in stackoverflow. For further Graph API question, I suggest you post in the dedicated AAD forum, you'll get better response there.