Get a list of Power BI refresh times across all apps in tenancy

[Anonymous]

I need to know the refresh times currently set on all our reports (in all apps) across the organisation as we are being throttled by microsoft

I saw on another similar question someone mentioned using the the following API call: https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistoryingroup

However, when I put in my groupId and datasetId (taken from the URL of the report, in the workspace) I just get the following error:

{
  "error": {
    "code": "ItemNotFound",
    "message": "Dataset [datasetId] is not found."
  }
}

Any tips on using the API and also automating this to get a report on refresh times?

[Icey · Accepted solution]

Hi @Anonymous ,

You need to open the dataset and then take the workspaceId and datasetId from the URL.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Icey  Any idea how I can make a Power BI dashboard on top of this? We have over 70 reports refreshing about 120 times per day so I would like to monitor the refresh times on a daily basis and make changes where necessary.

We organise our reports via 10-12 apps, each app has 5-10 power BI reports inside with varying refresh schedules