Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Active Directory connection to get groups and owners

I made a connection to the Active Directory of my company in order to create a report and see all the groups a user belongs too, this is apparently working without issues.

For the next step, I'd like to add to the visualization the Owner of each one of the groups, but I am unable to find this field through all the tables and fields the connection has.

 

Does someone know how to get that info with the Active Directory connection?

 

Thanks!

 

Regards,

1 ACCEPTED SOLUTION
ChrisMendoza
Resident Rockstar
Resident Rockstar

@Anonymous - looks like the [owner] is in the 'group' table as a record; my org apparently uses [managedBy] as [owner] = null.

image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

Hello, you could please place which fields you used to see the groups to which users belong??? in addition to this I am also looking for the licenses that a user is assigned.

I bring the user and group table and there is a lot of data but I do not get what I am looking for.

Thank you

ChrisMendoza
Resident Rockstar
Resident Rockstar

@Anonymous - looks like the [owner] is in the 'group' table as a record; my org apparently uses [managedBy] as [owner] = null.

image.png






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors