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}
2 Comments
- jorge_sennaNew Member
Maybe you can include the dataflow history in this endpoint too.
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Allow Managed Private Endpoint to be disabled/enabled per notebook
Could notebooks have an option to use or not use the workspace's Managed Private Endpoint (MPE)? MPE can significantly increase notebook startup time, even for notebooks that don't need private conn...frithjof_v13 hours agoCommunity ChampionNew21Views1like0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente1 day agoRegular VisitorNew80Views6likes1Comment