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

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.