Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
learner03
Post Partisan
Post Partisan

Refresh history query

This below is the attached refresh history of one of my report-

I have pro license and I have read that the refresh is timed out after 2 hours, but here I see that there are different refresh times. Some refresh time are 4 hours, some have failed etc. can you explain different scenerios please?

 

akapoor03_0-1635388469394.png

 

akapoor03_1-1635388514485.png

 

Thanks

 

 

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @learner03 ,

It seems to me that the time in the refresh history here is not so precise. Refreshes, like queries, require the model be loaded into memory. If there is insufficient memory, the Power BI service will attempt to evict inactive models, and if this isn't possible (as all models are active), the refresh job is queued. Refreshes are typically CPU-intensive, even more so than queries. For this reason, a limit on the number of concurrent refreshes, calculated as the ceiling of 1.5 x the number of backend v-cores, is imposed. If there are too many concurrent refreshes, the scheduled refresh is queued until a refresh slot is available, resulting in the operation taking longer to complete. On-demand refreshes such as those triggered by a user request or an API call will retry three times. If there still aren't enough resources, the refresh will then fail.(refer: link) The start time  of the record-breaking period could be the cloud service creates a query and the encrypted credentials for the on-premises data source. (queued time+refresh time)

Pls Try the following ways to check the refresh time。

1.According to the official document, you can select the History view by clicking on History in the refresh summaries page.

In this view, the data associated with a given refresh is based on up 60 most recent records for each scheduled refresh.

vluwangmsft_0-1635759331841.png

 

2.Use Rest API:

 

3. Collect logs from the on-premises data gateway app

 

 

Refer to:

https://hatfullofdata.blog/power-bi-dataflow-refresh-history/

https://stackoverflow.com/questions/62032270/from-powershell-get-refresh-history-in-group-from-power...

https://community.powerbi.com/t5/Developer/How-to-get-refresh-history-of-dataset-using-powerbi-REST-...

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @learner03 ,

It seems to me that the time in the refresh history here is not so precise. Refreshes, like queries, require the model be loaded into memory. If there is insufficient memory, the Power BI service will attempt to evict inactive models, and if this isn't possible (as all models are active), the refresh job is queued. Refreshes are typically CPU-intensive, even more so than queries. For this reason, a limit on the number of concurrent refreshes, calculated as the ceiling of 1.5 x the number of backend v-cores, is imposed. If there are too many concurrent refreshes, the scheduled refresh is queued until a refresh slot is available, resulting in the operation taking longer to complete. On-demand refreshes such as those triggered by a user request or an API call will retry three times. If there still aren't enough resources, the refresh will then fail.(refer: link) The start time  of the record-breaking period could be the cloud service creates a query and the encrypted credentials for the on-premises data source. (queued time+refresh time)

Pls Try the following ways to check the refresh time。

1.According to the official document, you can select the History view by clicking on History in the refresh summaries page.

In this view, the data associated with a given refresh is based on up 60 most recent records for each scheduled refresh.

vluwangmsft_0-1635759331841.png

 

2.Use Rest API:

 

3. Collect logs from the on-premises data gateway app

 

 

Refer to:

https://hatfullofdata.blog/power-bi-dataflow-refresh-history/

https://stackoverflow.com/questions/62032270/from-powershell-get-refresh-history-in-group-from-power...

https://community.powerbi.com/t5/Developer/How-to-get-refresh-history-of-dataset-using-powerbi-REST-...

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

lbendlin
Super User
Super User

Power BI timeout is 5 hours, not 2 hours.  2 hours is usually the data source timeout for SQL server, unless you overrride that.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors