Error "This File Is Too Large to Be Exported." When Extracting Data From Google Sheet

Issue

When attempting to extract data from Google Sheet, the following error may occur:

There was an error communicating with Google Sheets.

Invalid connection: Tableau could not connect to the data source.
The Google Sheets service reported an unrecognized error while processing this request.
This file is too large to be exported.

Environment

Tableau Desktop
Google Sheets

Resolution

A possible workaround is to connect to a copy of the affected Google Sheets workbook with any large sheets removed.

Cause

The ability to connect to Google Sheets greater than 10 MB is currently not built into the product.

Additional Information

For additional information about this limitation, refer to the following third party links below*:

* Although we make every effort to ensure links to external websites are accurate, up to date, and relevant, Tableau cannot take responsibility for the accuracy or freshness of pages maintained by external providers. Contact the external site for answers to questions regarding its content.

Discuss this article... Feedback Forum