Working with Cached Response Mode
When you set data refresh to Cached Response, your datasets and workbooks load from stored data whenever you open them or make changes. To see when your data was last updated, check the time in the upper-left corner of the Viewer, next to Cached Response.
Some dataset changes require real-time data, even if Cached Response mode is on. Cached data isn't available if you add or remove fields from your dataset, modify its criteria filters, or change a formula used in your dataset. Save your dataset changes to start using cached data again.
When you work with cached data, you can get the most current data at any time. To refresh cached data and see the most up-to-date results, click the Refresh icon.
The frequency of cached data refresh can be different for datasets and workbook visualizations:
Frequency to refresh cached data in datasets
The refresh frequency for cached data in your datasets adapts to your usage. Cached Response tracks when you view datasets, workbooks, or portlets, then schedules refreshes so the data's updated when you need it. Refreshing can happen as often as every hour or as rarely as every 24 hours, depending on your usage.
Frequency to refresh cached data in pivot tables and charts
Cached data in your pivot tables and charts is refreshed after 60 minutes of inactivity, and after a standard data refresh. For detailed information about cached data in pivot tables and charts, see Understanding Data Caching in Pivot Tables and Charts.