How can I auto refresh Google Sheets data source in Google Data Studio?

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?

Solution 1:

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

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