Data Studio
1.9K members online now
1.9K members online now
Ask questions about Data Studio
Guide Me

Google Sheets Data Connector Auto Refresh Solved

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi Guys,


I've seen many posts and some innovative solutions to Google Sheets Auto Refresh problem.


I had data being pulled via Google Sheet & only users with Edit access can refresh data. Which was a huge problem when so many people would use the Dashboard and not everyone can be given edit access.


I stumbled upon this solution somewhere and it's been working like a charm! So thought I'd post the solution.




Just un-tick the 'Enable Cache' and your report should pull in data more often.


My sheet only updates once a day, so haven't seen any issues. But if you did have a sheet with data being updated more often, would be worth looking at how things are going?