KNOWLEDGE BASE

Unable to Edit Data Connection for Google Analytics, Sheets or BigQuery on Tableau Server


Published: 31 Mar 2016
Last Modified Date: 05 Nov 2019

Issue

Unable to edit Data Connection for Google Analytics, Sheets or BigQuery on Tableau Server because "Edit Connection" is disabled.

Environment

  • Tableau Server
  • Google Data Sources (Analytics, BigQuery or Sheets) 

Resolution

Option 1:

To resolve, follow the steps listed in Set up OAuth for Google.

Option 2: 


From Tableau Desktop, connect to Google Analytics, BigQuery or Sheets and republish the data source to Tableau Server.

Cause

Google Analytics has not been set up with OAuth token.

Additional Information

The connection to Google BigQuery and Google Analytics is created through an OAuth access token. Database credentials do not need to be stored in Tableau, and all users connect through this access token, including Tableau Desktop users who want to create or edit workbooks using this connection.

An OAuth token is not required in Tableau Desktop if the Google account can be autheticated via two factor authentication in the browser. Tableau Server is not able to display the web interface for two-factor authentication.
Did this article resolve the issue?