Power BI Rest API Limit

[dalebidwell]

I'm building some admin reports, the current one i'd like to show who has access to all our datasets, of which there are 600 - 700. I'm using the Power BI Rest API via an app registration in Power BI Desktop , which works for most of the API functions but the GetDatasetUsersAsAdmin is limited to 200 so falls over with a 429 error, what would be the simplest method of handling this, i'd like to publish the report to the Power BI Service and refresh the dataset on a schedule.

Thanks,

Dale.

[dalebidwell]

@Anonymous thanks for the advice, I tried this earlier, when i tried to expand the returned users column from GetDatasetsInGroupAsAdmin, it just returns an empty table, where GetDatasetUsersAsAdmin returns a list of users for the same dataset, is there anything i could be doing wrong?

[Anonymous]

Perhaps you could try to use GetDatasetsInGroupAsAdmin instead? It will provide you with the same info for all datasets in a particular workspace/group.