5

I created a project in Data Studio connected to Google Sheets in Google Drive.

I need to update the data on the sheet periodically. I import the data from another Excel sheet but after doing this, I have to update the connection of the data sources in Data Studio.

Is there any way to update the Excel sheets without editing the connections?

Nimantha
  • 6,405
  • 6
  • 28
  • 69
Elias Tabarez
  • 71
  • 1
  • 4

2 Answers2

1

You can Update the excel sheets without editing the connections. you can force Data Studio to update the report cache by clicking Refresh enter image description here in the righthand side of the report header.

enter image description here

For more info check this link: https://support.google.com/datastudio/answer/7083608

Krishnaprasad AU
  • 76
  • 4
0

Uncheck the "Enable Cache" under Report Settings (Files > Report Settings):

Data Studio - Cache Control

Here is a description on how Data Studio caches data: Manage data freshness

Nimantha
  • 6,405
  • 6
  • 28
  • 69
João Cantini
  • 1
  • Hi, i uncheck the "Enable cache" but the problem persists. I import data in google sheet. After i go to data studio and i need to reconnect excel data source – Elias Tabarez Jan 09 '19 at 12:43