Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
dalebidwell
Frequent Visitor

Power BI Rest API Limit

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.

2 REPLIES 2
dalebidwell
Frequent Visitor

@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?

koostb
Regular Visitor

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

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

Top Solution Authors