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.
Thank you for providing your feedback on the effectiveness of the article.