Forum Discussion
How to Filter Azure AD Group Table in Power BI for Specific Group?
Hi Anonymous ,
Active Directory connector returns a list of Active Directory domains in the same forest as the specified domain or of the current machine's domain if none is specified.
To get Azure Active Directory data in Power BI Desktop, you can use Microsoft Graph API. The information from Azure AD is stored in Microsoft Graph, which means that you would need to create a custom connector to access it .
For more details, you could read related document:
Power Query Active Directory connector - Power Query | Microsoft Learn
ActiveDirectory.Domains - PowerQuery M | Microsoft Learn
Solved: How to show data from Azure active directory in Po... - Microsoft Fabric Community
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
A colleague of mine brought up an interesting point regarding the type of group we are trying to access. It seems that we are dealing with cloud groups, and the Active Directory connector I'm using in Power BI might not support these types of groups. I'm now considering if there's an alternative connector that can handle cloud groups or if using the Microsoft Graph API would be a viable solution to retrieve this data. Has anyone faced a similar situation or can offer insights on a suitable connector or approach for handling cloud groups in Power BI? Any guidance would be much appreciated!