Select An Org
Error "SyntaxError" or "A7AE75CC" Occurs When Connecting to Google Drive Spreadsheet
Publish Date: Jun 4, 2026
Description
When attempting to connect to a specific Google Drive spreadsheet in Tableau Prep or Tableau Desktop, one of the following errors occurs.
Tableau Prep Error:
Something went wrong and the application needs to restart.
Click Save As to save your work before restarting. Unsaved changes will be lost when the application restarts.
SyntaxError: Unexpected end of JSON input
at JSON.parse (<anonymous>)
at new ModularConnectionDialog (https://127.0.0.1:64288/static/vendor.js?1771007896002:2:3784728)
at Jg (https://127.0.0.1:64288/static/vendor.js?1771007896002:2:7378210)
at ki (https://127.0.0.1:64288/static/vendor.js?1771007896002:2:7396620)
at Qr (https://127.0.0.1:64288/static/vendor.js?1771007896002:2:7439633)
at dk (https://127.0.0.1:64288/static/vendor.js?1771007896002:2:7428552)
at Xj (https://127.0.0.1:64288/static/vendor.js?1771007896002:2:7428364)
at Ij (https://127.0.0.1:64288/static/vendor.js?1771007896002:2:7425063)
at https://127.0.0.1:64288/static/vendor.js?1771007896002:2:7373497
at $.unstable_runWithPriority (https://127.0.0.1:64288/static/vendor.js?1771007896002:2:7908367)
Tableau Desktop Error:
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.
Cause:
This behavior is caused by a security restriction configured on the specific Google Spreadsheet.
Google Spreadsheets have a security setting that allows file owners to disable the "Viewers and commenters can see the option to download, print, and copy" option. When this setting is unchecked, viewers cannot download the file.
When Tableau Prep or Tableau Desktop connects to read the data, it makes an API request to Google for the data in JSON format. Google's system treats this request as a file download. Because the download restriction is active, Google blocks the data payload. Tableau Prep receives an incomplete response, causing the JSON parsing error, while Tableau Desktop receives an insufficient permissions rejection.
Resolution
To resolve this issue, use one of the following options.
Option 1: Request permission changes
Contact the administrator or owner of the target file and request one of the following changes:
- Remove the "Disable download, print, and copy for commenters and viewers" setting from the spreadsheet's share settings.
- Grant "Editor" permissions to your Google account for the spreadsheet.
Option 2: Copy the file
If permission changes are not possible due to security rules, perform the following workaround:
- Create a copy of the original Google spreadsheet.
- Connect Tableau Desktop or Tableau Prep to the copied file that you own.
Additional Resources
Additional Information
For more information about Google spreadsheet, see Share files from Google Drive on Google Support.
About similar issues, check the below article or other possible causes.
Knowledge Article Number
005385947
Did this article solve your issue?
Let us know so we can improve!
