KNOWLEDGE BASE

Error "An error occurred when connecting to your data source. The data source might be corrupt or not valid." Connecting to a Google Sheet in Web Edit Mode


Published: 13 Nov 2019
Last Modified Date: 08 Sep 2020

Issue

When connecting to a Google Sheet file using the Google Drive connector in Web Edit mode, the following error appears:

"An error occurred when connecting to your data source. The data source might be corrupt or not valid."

 

Environment

  • Tableau Online
  • Google Sheets
  • Google Drive

Resolution

Workaround: 
  1. Connect to the Google Sheet in Tableau Desktop, and publish the data source to Tableau Online. 
  2. Connect to the published data source in Web Edit Mode.

Cause

This behavior is related to a known issue which is fixed on Tableau Online.
Did this article resolve the issue?