Is there API available to get the details of Day, Time & Refresh time booked (minutes)

[VikrantShinde]

Is there API available to get the Day, Time & Refresh time booked (minutes) which can be seen under Admin Portal => Refresh Summary => Schedule.

[v-saisrao-msft]

Hi @VikrantShinde,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[VikrantShinde]

It looks like I need to use "Capacities - Get Refreshables For Capacity" to get the averageDuration and startTime and then use this information to calculate the refresh hours booked. Also if the averageDuration is more than 30 mins then the time exceeding 30 mins have to be added to the next refresh window.

Example if refresh scheduled at 10 AM is having average time 45 mins, then it will be calculated as below

Refresh hours booked at 10 AM - 30 mins

Refresh hours booked at 10:30 AM ; 15 mins

Can you confirm if this understanding is correct.

[v-saisrao-msft · Accepted solution]

Hi @VikrantShinde,

Yes, you can use the Capacities - Get Refreshables For Capacity API to obtain the averageDuration and startTime of dataset refreshes. Since Power BI allocates refresh capacity in 30-minute slots, the refresh time must be managed accordingly. The initial 30 minutes are allocated at the specified startTime, and any duration exceeding 30 minutes is carried over to the next available slot.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[v-saisrao-msft]

Hi @VikrantShinde,
Thank you for reaching out to the Microsoft Fabric Forum Community. 

Power BI offers REST APIs to retrieve dataset refresh schedules and durations. The Get Refresh Schedule in Group API provides the scheduled days and times for dataset refreshes. However, it does not provide the exact next scheduled refresh datetime, only recurring patterns. To track actual refresh execution and duration, use the Get Refresh History API, which provides timestamps for past refreshes, including start time, end time, and duration. 

While there is no direct API to fetch the exact next scheduled refresh datetime, you can derive it by comparing the current date/time with the refresh schedule. By combining both APIs, you can effectively extract the day, time, and refresh duration (in minutes), similar to what is displayed in Admin Portal → Refresh Summary → Schedule. 

For more details, refer to the official documentation: 

Datasets - Get Refresh Schedule - REST API (Power BI Power BI REST APIs) | Microsoft Learn 

Datasets - Get Refresh History - REST API (Power BI Power BI REST APIs) | Microsoft Learn 

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you. 

[Deku]

Get Refresh Schedule In Group

Will return the days and times. Not sure you can get the datetimes of the next scheduled one though