Forum Discussion
saunders
Helper II
Helper IIGetDatasetUsersAsAdmin - Too Many Requests
Hi all, I'm trying to get all user access rights for datasets in our tenant via Power Query and PBI REST API but I get the following error below: Error: Data Source Error : DataSource.Error: Web.Co...
Hi saunders ,
the API doc states a max. of 200 requests per hour. So you'd have to split it up into 10 chunks to retrieve those values: Admin - Datasets GetDatasetUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs
You might consider using Power Automate for it instead, so you can export the results of the chunks into a central location. Setting up a custom connector in there is also much easier than in Power Query.
