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.
ImkeF
Community Champion
Community ChampionHi lbendlin ,
yes, of course, you would have to register an app to access this data.
lbendlin
Super User
Super UserThat's the beauty of Miguel's solution - no app required. Of course with the drawback that AAD is not supported on the PowerBI service (as far as I know? - would be happy to be proven wrong).