Data limit in Google Drive

You can store up to 2 million cells for spreadsheets that are created in or converted to Google Sheets.

Error message: Internal Error – An unexpected error occurred and the operation could not be completed.

If there are errors in your Google Sheet, such as #DIV/0! or #N/A, Tableau is unable to create an extract and an error message will appear. To resolve this issue, wrap the function with iferror() and have it return a blank, or any value that’s appropriate.

For example, the sheet below includes a #DIV/0! error.

The solution is to wrap the calculation in an iferror() calculation.