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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
powerbiexpert22
Impactful Individual
Impactful Individual

Query Caching in Power BI

how long below query cache persist in Power BI? will it be available after session is closed and do i need to additionally pay for this cache?

https://learn.microsoft.com/en-us/power-bi/connect-data/power-bi-query-caching

 

1 ACCEPTED SOLUTION
andrewsommer
Super User
Super User

  1. Query cache in Power BI Premium capacity persists for up to 60 minutes by default.
  2. It does persist across sessions; not tied to an individual user session.
  3. No extra cost for the cache; it's included in your Premium capacity SKU.
  4. You can configure or disable this caching behavior via the XMLA endpoint or admin portal.

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

View solution in original post

2 REPLIES 2
v-kpoloju-msft
Community Support
Community Support

Hi @powerbiexpert22,

Thank you for reaching out to the Microsoft fabric community forum.

Thank you for your question about query caching in Power BI. It’s an excellent performance optimization topic.

Also, thank you to @andrewsommer, for their helpful response. Much of the information provided is accurate and a great starting point. These are the alternative steps for your scenario along with the community member solution.
 
If your performance concern is significant, using import mode can eliminate query time altogether (at the cost of data freshness). You can define aggregation tables in your model to reduce query complexity and ensure more predictable performance.

Helps retain cache longer by reducing how often full dataset refreshes occur (since cache is cleared on full refresh). Use Power BI Premium Metrics App or XMLA based DMV queries to monitor cache hit/miss patterns and memory usage.

Let us know if you’re using Premium or shared capacity, and whether performance is a concern for a few users or at enterprise scale. That will help us suggest the best caching or modelling strategy for your case.

vkpolojumsft_0-1748434867460.png

 

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 for using Microsoft Community Forum.

andrewsommer
Super User
Super User

  1. Query cache in Power BI Premium capacity persists for up to 60 minutes by default.
  2. It does persist across sessions; not tied to an individual user session.
  3. No extra cost for the cache; it's included in your Premium capacity SKU.
  4. You can configure or disable this caching behavior via the XMLA endpoint or admin portal.

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

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.