This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Admin - Datasets GetDatasetUsersAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs
There is a limit to 200 requests per hour.
This API looks at each end point item (reports, dashboards, datasets, datamarts etc), i believe, and resolves the users/permissions for each associated dataset being consumed by the end point.
This is extremely valuable for dataset,report and workspace permissions and licensing management across the tenancy.
Unfortunately the 200 per hour means it is not a viable option, currently, for anything but small tenancies.
We can get the resolved users from each endpoint independently via specific API GetXXUsersAsAdmin.
The DatasetUsers API does not have a feature to get only direct Dataset assigned users (dataset access shared with user). Its all or nothing.
Im asking for an enhancement to the REST API to increase the number of calls allowed (unlimeted would be ideal!!) and/or to be able to limit/identify the source of the user permission on the dataset.
Similar to the "GET https://api.powerbi.com/v1.0/myorg/admin/groups/{groupId}?$expand={$expand}" - Get Groups as Admin with an expand or filter option for specific end points
This would give the flexibility to get a whole of tenancy dataset usership via the API.
Note: The APIs for workspace info, while comprehensive, dont lend themselves to automation of tenant wide data.
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/workspace-info-post-workspace-info
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/workspace-info-get-scan-result
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.