Forum Discussion

WilliamA's avatar
WilliamA
Helper I
1 year ago
Solved

Power BI query cache time limit

Hi all,   I have a report using direct query. it reads from a database and every hour a column gets updated with the current datetime.   when I use this report with query caching enabled, the las...
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi WilliamA ,

    • Since you mentioned that the report updates correctly in the Power BI Service but not in the embedded environment, it’s possible that caching is being applied at the embedding layer.
    • The query cache for Direct Query datasets lasts 1 hour and cannot be adjusted. Since Power BI Service updates correctly but the embedded environment does not, caching may be applied at the embedding layer.
    • Try enabling Automatic Page Refresh (APR) in the embedded setup or use the Power BI REST API to force updates.

     

    If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

     

    Should you have any further questions, feel free to reach out.

    Thank you for being a part of the Microsoft Fabric Community Forum!