Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@dskeane , refer if these can help
https://matt40k.uk/2016/06/getting-a-list-of-ad-groups-and-their-members-using-powerquery/
@dskeane , refer if these can help
https://matt40k.uk/2016/06/getting-a-list-of-ad-groups-and-their-members-using-powerquery/
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!
Never mind my last statement the two links attached by Amitchandak answer both sides of my question.
Again thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |