Was this page helpful?
Yes No
Have a comment? Please leave it here. Thanks for your feedback!
All Tableau Help > Tableau Help > 
Applies to: Tableau Desktop

Set Credentials for Accessing Your Published Data

When you publish a workbook to Tableau Online or Tableau Server, you can publish the data it connects to as an integrated part of the workbook (embedded into the workbook), or as separate, standalone data sources. In addition, if the data you’re publishing requires anyone who wants to view it to enter a user name and password, you specify how others get access to the data when they open the workbook.

The latter is true also when you publish a data source on its own.

This type of authentication to your data is independent of how people sign in to your Tableau Online or Tableau Server site. For example, to give people direct access to the data in a workbook, you would embed a designated database user’s credentials into the data source’s connection. But anyone viewing the workbook would still need to be able to sign in to the site on Tableau Online or Tableau Server to open your workbook.

This topic describes how to set authentication on data connections as part of the publishing process.

In this article

Note: This topic does not apply to connections to that do not require authentication, such as text files or Excel files. However, you can set authentication when you publish extracts of those data types.

Set the authentication type

For many types of connection you can embed a database user’s name and password, or set a type of impersonation. Specific exceptions are described in the later sections in this topic.

The following steps describe how to set authentication as part of publishing a data source or workbook. You can do this for each connection in the data source.

  1. In the Publish Workbook dialog box, go to the Data Sources area, which lists the workbook’s connections, and select Edit.

  2. In the Manage Data Sources popup, after you decide whether to publish the data source separately or as part of the workbook, select an authentication type for each connection in the data source.

    The available authentication types depend on the connection type, and they can include one or more of the following:

    Important: How you want to keep extracted data fresh is also a factor. If you want to set up an automatic refresh schedule, you must embed the password in the connection. In addition, if you’re publishing a cloud data connection to Tableau Online, the publishing steps will alert you if you need to add Tableau Online to the data provider’s authorized list.

Kerberos environments

(Tableau Server only.) Select Viewer credentials to use the user’s domain user name and password to access a Kerberos-enabled Teradata, PostgreSQL, Microsoft SQL Server, or Microsoft Analysis Services data source.

SAP HANA or Impala single sign-on

(Tableau Server only.) Select Viewer Credentials to authenticate users who access the data source in these environments:

OAuth connections

Some connections (for example, Salesforce, OneDrive, and Google) use a type of authentication in which the data provider sends a secure access token (using OAuth 2.0), so that the credentials themselves are not stored with Tableau. You need to create and embed these credentials after publishing, from the Data Connections page on the server.

Dropbox, OneDrive connections

For Dropbox and OneDrive, when you publish a data source or workbook and select Embedded password, Tableau creates a saved credential and embeds it in the data source or workbook.

Workbook connections to Tableau data sources

When you publish a workbook that connects to a Tableau Online or Tableau Server data source, rather than setting the credentials to access the underlying data, you set whether the workbook can access the published data source it connects to. Regardless of the original data type, the choice for server data sources is always Embedded password or Prompt users.

If you select to prompt users, a user who opens the workbook must have View and Connect permissions on the data source to see the data. If you select embed password, users can see the information in the workbook even if they don’t have View or Connect permissions.

See also

Comprehensive Steps for Publishing a Workbook