Skip to main content

Power BI

Needs Votes

Azure Active Directory

Vote (334) Share
Rinus's profile image

Rinus on 19 Aug 2015 16:18:31

Add Azure Active Directory as a data source.

Comments (36)
Rinus's profile image Profile Picture

rgoerwit on 05 Jul 2020 22:47:18

RE: Azure Active Directory

BTW, it's great that there is an AAD content pack, but it appears to deal with logs. It's not a tool for querying AAD. What we could really use is something that would, for example, allow us to query AAD and find out how many people are assigned various licenses, and how close we are to cap on any of them.

Rinus's profile image Profile Picture

rgoerwit on 05 Jul 2020 22:47:12

RE: Azure Active Directory

Azure is figuring prominently in the data source list - Azure SQL, Azure Analysis Services, Azure this, that - and it does seem odd that Azure AD is missing from that list, especially seeing as we can already query on-premises AD using Power Query and Power BI Desktop.

Rinus's profile image Profile Picture

Dustin Adam on 05 Jul 2020 22:31:18

RE: Azure Active Directory

'I agree, I managed to do this with a manual Query and poll against the AD Graph, but it still has certain limitations:

- The returned page has a 999 item limit, for larger organization with more than a thousand AD Accounts, this would create additional complications
- There are attributes and content that would be nice to have returned / accessible such as Profile Photo

Rinus's profile image Profile Picture

Kawabata Yoshihiro on 05 Jul 2020 22:19:16

RE: Azure Active Directory

I want to check Office 365 users by Power BI connect to Azure Active Directory.

Rinus's profile image Profile Picture

Alexander on 05 Jul 2020 22:13:18

RE: Azure Active Directory

Yes we really want this

Rinus's profile image Profile Picture

Paul Andringa on 05 Jul 2020 22:03:38

RE: Azure Active Directory

I can only add my support for this requirement, it exists for Active Directory but not for AAD and it is much needed to add value to the reports from our data sources.