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

The 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.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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