Forum Discussion

dalebidwell's avatar
dalebidwell
Frequent Visitor
5 years ago

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.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

  • dalebidwell's avatar
    dalebidwell
    Frequent Visitor
    5 years ago

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