Google Sheets Data Connector Auto Refresh Solved
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?