1.4K members online now
1.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

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.

 

snip_20171123084221.png

 

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?

 

Cheers,

 

Bharat