Azure Active directory Groups

Thanks for the reply.

 

I have already gone through but I need all list of groups with each groups member counts in single excel sheet. However, I tried to get in Excel sheet by OData Feed option (Goto excel --> Data -->Get Data -->from Other sources) but while counting members of each group it is taking too much time (more than 2 days).

 

Please let me know any other ways to get all groups in single excel sheet with members count of each groups. 

Hi,

 

You can use two api(s). First, get the list of groups and then members of each group.

 

For Gettting Group list:

https://docs.microsoft.com/en-us/graph/api/group-list?view=graph-rest-1.0&tabs=csharp

 

For Getting Members:

https://docs.microsoft.com/en-us/graph/api/user-getmembergroups?view=graph-rest-1.0&tabs=http