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

Publish a Data Source

When you are ready to make a data source available to other Tableau Desktop users, you can publish it to Tableau Server or Tableau Online. If the data source is in a workbook that you published to Tableau Server or Tableau Online, you can make it available by saving it, provided it’s an embedded Excel or text file. For details, see Save a Data Source on the Web.

Note: If you haven't yet read about best practices for creating data sources and when to create an extract, see Best Practices for Published Data Sources.

In this article

Publishing steps

The following steps give an overview of the publishing flow you will use regardless of the type of data or the server you publish to. Below these steps you can find supplemental information for authentication types and using the Tableau Bridge to refresh extracts of local data sources.

  1. Select ServerPublish Data Source.

    If your workbook is connected to multiple data sources, select the one you want from the submenu.

  2. If you’re not already signed in to Tableau Server or Tableau Online, sign in now.

    How you sign in depends on how your administrator set up your environment. For information, see Sign in to Tableau Server or Online.

  3. In the Publish Data Source dialog box, do the following:

  4. If you are publishing file-based data that is on a Windows mapped drive, or using images that will not be available from the server, select Include external files.

    When you include external files, copies of the files are put on the server as part of your data source. Copies of files are also put on the server and included as part of the data source when you publish extracts of multi-connection data sources that contain a connection to file-based data such as Excel. For more information about the implications of publishing extracts of multi-connection data sources, see Extracts of multi-connection data sources that contain connections to file-based data

    If you do not want to publish the external files to the server, change the connection information so that the data source references a full UNC path. For example, rather than connecting to D:\datasource.xls, you would connect to \\filesrv\datasource.xls.

  5. By default, during the publishing process, Tableau updates the workbook connection to use the new published data source. It also closes the local data source.

    To continue using the local data source instead, clear the Update workbook to use the published data source check box.

    Note: If you select Undo after publishing the data source, Tableau will revert to using the local data source, but the data source will remain published. In addition, Tableau does not replace a local data source when you publish a cube (multidimensional) data source to Tableau Server. (Tableau Online does not support publishing cube data sources.)

  6. Click Publish.

  7. (Optional) Set up a refresh schedule on the server.

    After you click Publish, you are redirected to the site you published to, open in the web browser. There, you are prompted to set up the refresh schedule. If you published with a live connection to on-premises data, or an extract of a data source to Tableau Online that Tableau Online cannot reach directly, you schedule refreshes using Tableau Bridge.

    For more information about refreshes and schedules, see any of the following topics:

Publishing with a Web Data Connector

To publish a web data connector data source, you need to import the web data connector to the server before you can set up a refresh schedule. You can do this only on Tableau Server.

You can refresh some web data connector data sources on Tableau Online, using Tableau Bridge.

For information, see Web Data Connectors in Tableau Server in the Tableau Server Help or Use Tableau Bridge to Expand Data Freshness Options in the Tableau Online Help.

Using hidden fields in workbooks

Workbooks connected to a published data source respect the state of hidden fields in the published the data source.

You can address this issue in one of the following ways:

For information, see Hide or Unhide Fields.

See also