Google sheet calculated value does not get updated in Data Studio report

Right now I am using Google Sheets to convert some data from Google Analytics into sheets.

(The value of an Event where i add a number to to create a new calculated value. This is stored in a separate column in a new sheet.)

When I run the report in Google Sheets it gets the new statistics out of GA and into the sheet, but when i reload the report in Data Studio new the calculated value is not updated. Am i missing something?

I was hoping that everytime you reload the report in Data Studio it fetches the latest info from the Google Sheet.

Google sheet calculated value does not get updated in Data Studio report

I believe the data will reload every 2 hours, to refresh the data instantly you should use the 'Refresh' button in the top left hand corner, this will refresh the data source, where as refreshing your browser won't.

Google sheet calculated value does not get updated in Data Studio report

I believe the data will reload every 2 hours, to refresh the data instantly you should use the 'Refresh' button in the top left hand corner, this will refresh the data source, where as refreshing your browser won't.