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: 15 Jan 2020

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
  • Google Sheets

Resolution

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 known, 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?