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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
Anonymous
Not applicable

Scheduled Cache Refresh and Query Cache

I have a report in a Premium capacity workspace and have turned on Query Caching in hopes to speed up the report load time. My question is when does it refresh? Do I set the refresh frequency using the Scheduled cache refresh as referenced in this article? It specifically mentions the refresh works for dashboard tiles, but I have been unable to find if it applies to query caching for report data as well. Any help would be much appreciated!

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @Anonymous 


The Query Caching is automatically controlled by the Power BI Service. 


If there is a change to the underlying dataset the Power BI engine is smart enough to know that there has been a change. It will then expire the cash so it gets the latest data.

 

Also the Query Cache does have a limit (Not sure what that is and will expire after a certain time)

 

I have found that this works really well and you always get the latest data.





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

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @Anonymous 

 

No it will actuall speed things up, the engine is VERY good at making things faster!





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

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @Anonymous 


The Query Caching is automatically controlled by the Power BI Service. 


If there is a change to the underlying dataset the Power BI engine is smart enough to know that there has been a change. It will then expire the cash so it gets the latest data.

 

Also the Query Cache does have a limit (Not sure what that is and will expire after a certain time)

 

I have found that this works really well and you always get the latest data.





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

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Very cool, thank you @GilbertQ! And will the cache updating in the background slow down the load time of the report?

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.