KNOWLEDGE BASE

Error "Invalid Service Account. To continue, enter a valid service account (json)" When Connecting Google BigQuery


Published: 16 Mar 2022
Last Modified Date: 19 Mar 2022

Issue

When signing in to Google BigQuery using a Service Account (JSON) file in Tableau Desktop, the following error may occur:

Authentication failed.
Error Code: FF9C14D9
Invalid Service Account. To continue, enter a valid service account (json).

Environment

  • Tableau Desktop 2021.4
  • Windows
  • Google BigQuery
  • Proxy configuration required for Google APIs

Resolution

  1. Open the following file in a text editor, such as Notepad or Sublime Text: C:/Program Files/Tableau/Tableau 2021.4/bin/jre/conf/net.properties
  2. Add the following lines and include the values for the proxy host and port:
    http.proxyHost=<proxy host> 
    http.proxyPort=<proxy port> 
    https.proxyHost=<proxy host> 
    https.proxyPort=<proxy port>​​​​​
  3. Edit the following line:
    jdk.http.auth.tunneling.disabledSchemes=Basic
    so it reads:
    jdk.http.auth.tunneling.disabledSchemes=
    
  4. Restart Tableau Desktop to apply the change.

Cause

The connection to Google APIs in your environment requires configuration of a specific proxy.
Did this article resolve the issue?