How to get refresh History of all the Datasets in all workspaces using power Automate.

[KarthikAkkala]

I had a requirement of creting a power BI report with refresh Historey of all the datasets in all workspaces. is there a way to get it done. Kindly help me on this

[andrewsommer · Accepted solution]

You can do this with the Power BI REST API and the Power Automate HTTP connector. 

You will need:

• You have a Power BI Service Principal or user with Admin API access.
• You can use Power Automate Premium (required for HTTP requests).
• Your Power BI tenant has enabled Admin APIs in the tenant settings.

Get all workspaces:

GET https://api.powerbi.com/v1.0/myorg/admin/groups?$top=5000

Get datasets for each workspaces

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets

Get refresh history for each dataset

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes?$top=10

Please mark this post as a solution if it helps you. Appreciate Kudos.