Azure Active Directory
Add Azure Active Directory as a data source.
Rob Kruse commented
It is a bit insane that you can connect to AD but not to AAD - this makes zero sense.
My org *needs* the Azure AD Activity Logs Content Pack to work with Power BI Pro GOV. I cannot believe it doesn't work.
David PROVOST commented
This is expected here too, to consolidate AAD users with some external organization file.
We need Azure AD connector for Power BI badly.
Or at least Graph API connector.
Especially after Microsoft broke OData connector, and we can't use it to connect to Graph API anymore
James Houck commented
Absolutely need this! Imagine creating only one security role in our models that is applied to all users in the organization. This one security role uses logic based on the AAD groups to filter the data correctly. This would basically give us seamless RLS by simply adding users to the appropriate AAD groups at setup.
Michael Buckingham commented
I'd like to see it more tightly integrated. For example, Power BI could automatically recognize an email address or and SPN and offer relevant data for that user. Ideally this would include Office Graph data too.
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.
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.
Dustin Adam commented
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
Kawabata Yoshihiro commented
I want to check Office 365 users by Power BI connect to Azure Active Directory.
Yes we really want this
Paul Andringa commented
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.