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

Updating Google Spreadsheet as Dashboard Data Source

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi Guys,

 

I have a dashboard with Google Spreadsheet as data source.

Now I am trying to periodically update the spreadsheet located in Google Drive using the following API:

https://developers.google.com/drive/v3/reference/files/update

The weird thing is, the dashboard didn't get updated after I updated it through API.

 

I have to manually do some random changes to the spreadsheet (in my case i wrote random letters then deleted them in order to trigger Google Spreadsheet autosave feature) to reflect Google Spreadsheet changes to the dashboard.

 

Is this some kind of bug? 

 

Thanks

Updating Google Spreadsheet as Dashboard Data Source

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

There is a manual refresh button located next to the dashboard page drop down menu button. You can use this button to update your data sources at any time. Otherwise, the data sources will update automatically every 12 hours. 

Updating Google Spreadsheet as Dashboard Data Source

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Yes, I have clicked that refresh button and also refreshed the whole dashboard page. It didn't work. I had to manually trigger Google Spreadsheet autosave feature as I described above, then click refresh button to reflect the changes.

 

For the second one, I haven't tried that but I think it would be more convenient if changes could be reflected in real time.