KNOWLEDGE BASE

Error "Bad Request: The data source does not contain the expected data Error Code A7AE75CC" Connecting to Google Drive


Published: 14 Apr 2022
Last Modified Date: 14 Apr 2022

Issue

When you try to connect to Google Drive, the following error occurs: 
An error occurred while communicating with Microsoft Excel
Bad Request: The data source does not contain the expected data.
Error Code: A7AE75CC Google Drive has rejected this request because of insufficient permissions.

Environment

  • Tableau Desktop
  • Tableau Server
  • Tableau Online
  • Google Drive

Resolution

Reduce the size of the file you are connecting to. For example, consider copying the sheet(s) you want to connect to into a new workbook that doesn't contain any large sheets. 

Cause

Google's API does not permit connecting to files larger than 10MB 

Additional Information

For additional information about this limitation, refer to the 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.
Did this article resolve the issue?