Forum Discussion
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...
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!
Hi WilliamA , The query cache duration for DirectQuery datasets is 1 hour You could try for Automatic Page Refresh
Enable Automatic Page Refresh:
- Go to Format → Page Refresh and set a shorter refresh interval. This works for DirectQuery in Power BI Service.
Optimize Queries:
- Focus queries on the frequently changing data (datetime column).
You could also check for live connection if it supports
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
- Focus queries on the frequently changing data (datetime column).
Hi WilliamA ,
If the answer posted by Akash_Varuna was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!