Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello everyone,
I'm facing a challenge in Power BI while working with Azure Active Directory data. I've successfully imported the Azure AD 'group' table into Power BI using the Active Directory connection. However, I'm encountering difficulties in filtering this table to locate a specific group and extract user details from it.
My process so far:
After applying the filter, I received a message stating "This table is empty." This suggests that either the group isn't present in the loaded data or I'm missing something in my approach.
Could anyone provide guidance on:
Any help or insights would be greatly appreciated!
Solved! Go to Solution.
Hi @BPFAFF ,
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.
Hi @BPFAFF ,
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!
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |