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.

or

Unable to complete action
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 Cloud
Google Drive

Resolution

Option 1

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.

Option 2

Verify and grant permission of this file for this Google account.

Option 3
If you cannot connect to a particular Google Sheets (.gsheet), check to see if the file contains pivot tables. If pivot tables are included, delete them, or copy the pivoted data to another Google Sheets and connect to it.

Cause

Root cause 1

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

Root cause 2

The Google account has insufficient permission of this file.

Root cause 3
The ability to connect to Google Sheets that contains pivot tables is not currently built into the product. To voice your support, please add your vote to the following Community Idea for this feature.

Idea:
Support connections to Google Sheets that have a tab with a pivot table
Allow Google Sheet with pivot table

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.

You may receive this error message above also when the Google account have insufficient permission if the file is shard from another place.
Under Google Drive, right click the file from "Shared with me". If the "Move to" is disabled, this Google account has insufficient permission and as a result, Tableau has insufficient permission when connecting to this file under this Google account.

. User-added image

2. There are two ways to grant permissions:

Choose "Make a copy" and move the copy to "My Drive" somewhere. Then Tableau has the permission connecting to this copy file under this Google account.
The file owner can transfer the ownership to this Google account so that this Google account has the "Move to" permission. Then just move to "My Drive" somewhere and Tableau has the permission.