Error When Opening a Published Workbook "This sheet uses data that's on a Google Drive database"

Issue

Error when opening a published workbook connected to files in Google Drive the following error messages will display:

Unable to connect to data source with the supplied credentials, or no credentials provided.
Tableau needs an unexpired OAuth refresh token to connect to the data. Authorise refresh tokens or ask the datasource owner for help.
This sheet uses data that's on a Google Drive database.
You need to sign into that server.

User-added image

Environment

Tableau Cloud
Tableau Server
Google Drive

Resolution

There are two possible causes and two different solutions.

Option 1

The credentials are not embedded into the data source the workbook is using.

Embed the credentials for Google Drive in Tableau Cloud as instructed below.
1. Select Menu>Server>Publish Data Source>(data source name) in Tableau Desktop.
2. Publish the data source to Tableau Cloud leaving Authentication option as "Prompt User". Then, a new tab will open in your browser.
3. Open Connections tab and click option (...)>Edit Connection.
4. Select Embedded credentials in the connection>Select an Account>Add a Google Drive Account. Enter the credentials for the Google Drive.
5. Click Save.
6. Replace the data source to the published data source in Tableau Desktop. For more information on replacing data sources, please see this Tableau Online Help.

Option 2

The Google Cloud Platform does not have the "Google Sheets API" selected.

1. Sign in to the Google Cloud Platform.
2. Enable "Google Sheets API". For instructions on how to enable an API when working in your Google Cloud project, please refer to these third-party instructions.

Cause

1. Credentials for Google Drive are not embedded. The "Embedded password" option is not supported when publishing the data source connected to Google Drive.

User-added image