As an owner of a report I have in Looker Studio, I have a “Refresh Data” option available to force a refresh. For the viewers of that report, they do not have that specific option. I have seen where the data has NOT refreshed for them, even when first opening the report. It appears as if the data is refreshed as it spends time calculating each displayed stat. But the info in a couple of the fields is not accurate. When they closed and then reloaded the report, it displayed correctly. Is there a way for “Viewer” to refresh the data manually?
Hello,
Not sure what type of data source you’re using, but the following trick works for me with BigQuery Custom SQL source (ugly but works)
Using a boolean parameter that you can call “REFRESH” and add at the top of the report does the trick : Whatever you click, true or false, it will refresh the custom SQL query from BigQuery.
People are able this way to refresh the data.
Be aware that since you refetch full data, if you’re linking a huge table or doing joins, each click might be ‘expensive’ (all relative).
By extension, I suppose that any parameter would do the trick by the way, for example building params for the date range selection - Switching dates will refetch data also..
Hope that helps.
Good thought! I’ll give that a try and see if I can trigger a refresh that way.
Thanks for the suggestion!
Wick