Skip to main content

Power BI

New

REST API - Get Refresh History As Admin

Vote (25) Share
Alex Gorbunov's profile image

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)
Alex Gorbunov's profile image Profile Picture

Jorge Bernardo de Paula Senna on 08 May 2024 20:41:12

RE: REST API - Get Refresh History As Admin

Maybe you can include the dataflow history in this endpoint too.