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

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.

Additional Information

Discuss this article... Feedback Forum

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.