Forum Discussion
Power BI Rest API GetGroupsAsAdmin users expansion no longer working for personal workspaces
For larger tenants, this meant bumping into API Limits all the time .. The GetGroupsAsAdmin API is called once for every workspace, and will return all the specified information in a single go(Maximum 200 requests per hour).
There’s a limit for 5000 workspaces per call, but you can work your way around this by intelligently looping over this.
For larger tenants, this meant bumping into API Limits all the time .. The GetGroupsAsAdmin API is called once for every workspace, and will return all the specified information in a single go(Maximum 200 requests per hour).
There’s a limit for 5000 workspaces per call, but you can work your way around this by intelligently looping over this.
Hi,
Tx for the reply but this is actually my point: we do not want to loop, we do not have more than 5000 workspaces but we have noticed that there is a difference in behavior with the expand=users option compared to before: we no longer get user information back for Personal workspaces so our expand-based solution currently no longer works and I would like to know if this is a regression/bug or a planned change by Microsoft and if so, what would be a solution to avoid going back to looping and hitting the API limitations.
Since the Groups GetGroupsAsAdmin parameter $expand=users only works for "New Workspace Experience" workspaces, we're having to loop through our non-upgraded workspaces using Groups GetGroupsUsersAsAdmin for every "type=group" workspace. With over 200 groups, just refreshing preview in Power Query editor will hit this limit, making development a time-consuming challenge.
A hint: use Table.FirstN while developing queries in Query Editor if you're working against throttling issues with APIs. You can remove the step once everything is looking good.