Loading

Error "connectionSettings is undefined" Connecting to a .gsheet File

Date de publication: Feb 22, 2026
Description

When connecting to a Google Sheet file (.gsheet) using Prep web authoring, the following error may occur:
 

Something went wrong and the page needs to reload.
Your last changes may be lost when the page reloads.
Details:
Error: connectionSettings is undefined
 

Additionally, the following error messages occur when connecting to the same file:
 

In Tableau Prep Builder: 
Error: Unsupported connection class cloudfile:googledrive-excel-direct

In Tableau Desktop:
An error occurred while communicating with the Microsoft Excel (Google Drive) data source 'Untitled Data Source'
Bad Request: The data source does not contain the expected data.
Error Code: A7AE75CC
Google Drive has rejected this request because of insufficient permissions.
 

Cause

The .gsheet file exceeds the file size limit for the Google Drive API (10 MB).

 

Résolution

Try the following workarounds:
 

Option 1

  1. In a web browser, open the Google Sheet file (.gsheet) and download the .gsheet file as an Excel file.
  2. Upload the Excel file in Google Drive.
  3. Connect Tableau to the Excel file in Google Drive.

 

Option 2

Split the data among smaller .gsheet files, and then combine them using a Union step.

 

Numéro d’article de la base de connaissances

001497411

 
Chargement
Salesforce Help | Article