Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
@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?
Perhaps you could try to use GetDatasetsInGroupAsAdmin instead? It will provide you with the same info for all datasets in a particular workspace/group.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
61 | |
31 | |
30 | |
29 | |
22 |
User | Count |
---|---|
51 | |
47 | |
31 | |
15 | |
12 |