KNOWLEDGE BASE

Google Sheets Live Published Connection Fails to Refresh on Tableau Server


Published: 14 Sep 2017
Last Modified Date: 18 Nov 2017

Issue

A Live published connection to Google Sheets fails to refresh and shows new data on Tableau Server 10.3.2.

Environment

  • Tableau Server 10.3
  • Google Sheets

Resolution

Option 1

As a Tableau Server Administrator, upgrade to Tableau Server 10.4.1 or 10.3.5. For more information, see Upgrading Tableau Server in Tableau Help. 

Option 2

As a workaround, reset the timezone on the computer where Tableau Server is installed to UTC -2.

Cause

The issue occurs because of the way timezone is converted in timestamps received from Google Drive API. It is related to a known issue (ID: 691492) which has been fixed in a recent release of Tableau Server. 
Did this article resolve the issue?