Google Sheets Extract Refresh Fails on Tableau Public

To resolve this issue, affected users must refresh their credentials and republish their workbooks from the Tableau Desktop application as demonstrated below.

Reconnect to Google Drive from Desktop

1. From Tableau Desktop, open the workbook that has the issue.

2. Select Data Source at the footer menu. A browser window will open for you to sign in with your Google account.
   
    
   
   

3. Follow the steps in the browser to complete the sign-in. You’ll see a message similar to the following.
   
    
   
   

4. After you sign in, refresh the data source by right-clicking on your data source and selecting Refresh. 
   
    
   
   

5. Return to the sheet, and you should see the data refreshed. Then, publish the workbook to Tableau Public.

   1. Be sure to select the checkbox for Keep my data in sync with the data source using saved credentials.
      
       

6. Once the publish is complete, the Request Data Refresh button should appear again below the viz.