Forum Discussion
Solved
GetDatasetUsersAsAdmin - 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.
If your org supports AAD you might be much better off using the Power BI Rest API custom connector. Works very well for us, at least on the desktop.
