Alex Gorbunov on 22 May 2023 03:38:25
We need to get refresh history for all datasets in all workspaces in the organisation.
There are non-admin APIs at the moment that require you to assign Service Principal to each workspace (which is not an option for big organisations with hundreds of workspaces):
1. Datasets - Get Refresh History: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history
GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/refreshes?$top={$top}
2. Datasets - Get Refresh History In Group: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history-in-group
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes?$top={$top}
It would be great to have an admin version of these APIs similar to others like GetDatasetsAsAdmin, GetGroupsAsAdmin, etc. Something like this:
GET https://api.powerbi.com/v1.0/myorg/admin/datasets/{datasetId}/refreshes?$top={$top}
and
GET https://api.powerbi.com/v1.0/myorg/admin/groups/{groupId}/datasets/{datasetId}/refreshes?$top={$top}
- Comments (1)
RE: REST API - Get Refresh History As Admin
Maybe you can include the dataflow history in this endpoint too.