Waiting for graph.microsoft.com

[StuartRichards]

I'm trying to pull the list of members for each O365 Group we have. The function to do it works fine with just a few Groups in the list to evaluate. If I go much above about 50 groups to process, PowerBI just sits there forever saying 'waiting for graph.microsoft.com'. Anyone know if there's some sort of limit or throttle that would prevent this query working?  It's not actually a huge volume of info so would seem weird if we were hitting a throttle.

[Anonymous]

@StuartRichards,

What method do you use to pull list of members for each O365 Group? How do you take the whole procee for 50 groups in Power BI?

Regards,
Lydia

[StuartRichards]

I have a table with all the GroupID's listed in a column. I then have a Column defined using a custom function that takes the GroupID as a parameter and should pull the list of members of the group.

OData feed

https://graph.microsoft.com/v1.0/groups/{GroupID}/members

This works fine if there's less than about 50 Groups in the list but just gets stuck and sits forever saying 'waiting for graph.microsoft.com' if more than about 50.