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.
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.
@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
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.
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |