Forum Discussion

StuartRichards's avatar
StuartRichards
Frequent Visitor
8 years ago

Waiting for graph.microsoft.com

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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      StuartRichards
      Frequent Visitor

      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.