Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
1 year ago
Solved

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

 

Need Help
  • andrewsommer's avatar
    andrewsommer
    1 year ago
    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.

2 Replies

  • andrewsommer's avatar
    andrewsommer
    Super User
    1 year ago
    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.

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support
    1 year ago

    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.

     

    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.