Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
@koostb 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?
Perhaps you could try to use GetDatasetsInGroupAsAdmin instead? It will provide you with the same info for all datasets in a particular workspace/group.