This content has been marked as final. Show 2 replies
How you might implement a solution depends on what their data source is, and how it is hosted. Do you happen to know this information?
Hi Phyllis, Two easy ways to achieve what you asked:
- Set sever refresh cache interval as 5 mins (at Server Config - Data Connections tab) if it is Ok with all other workbooks since this setting is server wide setting
- If option 1 is not feasible, embed your view with refresh=yes option. This can be done by publishers. After workbook view is published and you have the embedded URL, create one additional view pointing to previous one with ?:refresh=yes at the end of embedded URL. You hide the previous view but only explosee this new view to users. So the new view will ALWAYS get the latest data from your data sources.
Hope this helps.