KNOWLEDGE BASE

Error: "Unable to evaluate JSON path expression with the given JSON payload." When Connecting to Google Sheets


Published: 14 Mar 2017
Last Modified Date: 03 Aug 2017

Issue

When connecting to Google Sheets with Tableau Desktop, an error may occur when selecting a Sheet:

"Unable to evaluate JSON path expression with the given JSON payload."

Environment

  • Tableau Desktop 10.0.0 and later versions
  • Google Sheets

Resolution

Option 1:

Upgrade to Tableau Desktop 10.2.2. For more information, see Upgrading Tableau Desktop.


Option 2:

The sheets can still be searched for in the search box even if the list is not populated. If a specific sheet's name is know enter it into the search box and a connection can be made.

 

 

Cause

The JSON error occurs after creating a Google Sheets connection and such sheet(s) contain some nulls in the data.
Did this article resolve the issue?