AD Group members

[dskeane]

Looking to get a list of AD Security Groups and the members that are associated with that group. I do have the AD connector working and looking to figure out what table holds that information, I tried looking in groups and inetorgperson and am not able to see or return the value.

What I am looking for is to be able to list all active security groups then in a seperate data table see the associated memebers of that group. 

Any help is appreciated. 

[amitchandak · Accepted solution]

@dskeane , refer if these can help

https://matt40k.uk/2016/06/getting-a-list-of-ad-groups-and-their-members-using-powerquery/

https://dataninja.medium.com/get-members-of-a-security-group-in-power-bi-using-power-query-c458163ca...

[dskeane]

That informatoin is good and I believe answers my question. It sure does answer one part which is the Group table Column "securityprincipal" was holding the informatoin i was looking for. The next part I cant seem to figure out is if I need to create a relationship to the user table or I just missed the information in some instructions. 

Amitchandak, thank you!

[dskeane]

Never mind my last statement the two links attached by Amitchandak answer both sides of my question. 

Again thanks!