How to Publish Data Source in Tableau

Publishing a data source in Tableau is one of the most effective ways to move from creating isolated reports to building a reliable, scalable analytics environment. This simple action allows you to create a single, authoritative version of your data that your entire team can use. This article will walk you through exactly why you should do it and how to get it done, step by step.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Is a Published Data Source?

Normally, when you connect to data in Tableau Desktop, that connection information - the file path, the server address, the joins, the custom calculations - lives inside your specific workbook file (.twb or .twbx). If you want to use the same data setup in a new report, you have to build it all over again.

A Published Data Source is a centralized, stand-alone data connection that you publish and store on your Tableau Server or Tableau Cloud site. Instead of existing inside a single workbook, it becomes a reusable asset. Anyone with the proper permissions can then connect to this pre-built data source directly from Tableau Desktop to create new workbooks, ensuring everyone is working from the same foundation.

The Top Reasons to Publish Your Data Sources

You might wonder if taking the extra step to publish is worth it. For any team that wants to be more data-driven, the answer is a resounding yes. Here are the key benefits:

• A Single Source of Truth: This is the biggest advantage. When everybody connects to the same published source, you guarantee consistency. The definitions, calculations, field names, and data groups are identical for all users. No more arguing over whose "Sales" number is correct because everyone is pulling from the same verified dataset.
• Massive Time Savings: Imagine you've spent hours connecting multiple tables, creating complex joins, and building 20 essential calculated fields. By publishing the data source, you do that heavy lifting just once. Your colleagues can skip the entire setup process and jump straight into building visualizations.
• Better Performance: You can publish your data source as an "extract," which is a snapshot of your data stored on the Tableau Server. You can then schedule regular, automated refreshes for this extract during off-hours (like overnight). This offloads the processing workload from individual computers and frees up database resources during the workday.
• Simplified Security and Governance: Publishing a data source gives you centralized control. You can set permissions to determine who can connect to, view, or edit the data. It also allows you to embed database credentials securely, so individual users don’t need direct access to the underlying sensitive database.
• Empowers Self-Service Analytics: By providing your team with clean, curated, and easy-to-understand data sources, you empower them to answer their own questions without needing help from a data expert. They don't have to worry about data transformations, they can just drag and drop with confidence.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Your Pre-Publishing Checklist

Before you hit the "Publish" button, a few minutes of preparation can make your data source much more useful for your team. Here’s a quick checklist to run through:

1. Tidy Up Your Data Pane: Rename fields to be intuitive and human-readable (e.g., change cust_ref_id to Customer ID). Hide any fields that are duplicated, irrelevant, or won't be used in analysis to reduce clutter.
2. Set Default Properties: Assign the correct data types to each field (e.g., string, number, date). For geographical fields like "State" or "Country," assign the right geographic role so they map correctly. You can also set default aggregations (e.g., SUM, AVG) and number formatting (e.g., currency, percentage).
3. Create Core Calculations and Groups: Build any widely used calculated fields directly into the source. For example, if your team always needs a Profit Margin calculation, create it here so no one has to reinvent it. Do the same for custom groups or hierarchies (e.g., grouping products into categories).
4. Decide: Live vs. Extract:

Step-by-Step: How to Publish a Data Source in Tableau

Ready to go? Follow these steps to publish your first data source from Tableau Desktop to your server.

Step 1: Connect to and Prepare Your Data

Start in Tableau Desktop. Connect to your data as you normally would, whether it's from an Excel file, a SQL database, or a cloud application. On the "Data Source" page, set up your joins, relationships, and unions. Click over to a worksheet and implement your pre-publishing checklist items: renaming fields, hiding columns, creating calculations, and so on.

Step 2: Sign In to Your Tableau Server or Cloud Site

Before you can publish, you need to be connected to your Tableau environment. In the top menu, go to Server > Sign In... Enter your Tableau Cloud site URL or Tableau Server address, and then provide your credentials to log in.

Step 3: Begin the Publishing Process

There are two easy ways to start the publishing workflow:

• In the Data pane on the left, right-click the name of the data source you want to publish and select Publish to Server...
• Alternatively, go to the top menu and select Server > Publish Data Source > [Your Data Source Name].

This will open the "Publish Data Source to Tableau Server" dialog box.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 4: Configure the Publishing Options

This dialog box is where you define all the important settings for your shared data source.

Project, Name, and Description

• Project: This is the folder on your Tableau Server where the data source will be stored. Choose the appropriate project, such as "Marketing Analytics" or "Default."
• Name: Give the data source a clear, descriptive name. Use a consistent naming convention if possible, like Sales - Global Sales Data - Daily Extract.
• Description: This is incredibly important for teamwork! Add a description explaining what data is included, where it comes from, and who to contact with questions. This context is invaluable for your colleagues.

Permissions

Click the "Edit" button next to Permissions. Here, you can define exactly who can do what with your data source. You can set rules for individual users or entire groups. You can grant capabilities like "Connect," to allow users to build reports from it, or "Save," to allow them to edit and overwrite the original. It’s a best practice to start with the most restrictive permissions necessary and grant more access as needed.

Authentication

This setting controls how Tableau will access the underlying database after the data source is published.

• Prompt User: When a user connects to this data source, Tableau will ask them to enter their own credentials for the original database (e.g., their username and password for Snowflake or Redshift).
• Embedded Password: The database credentials you used are encrypted and stored within the data source on Tableau Server. When a user connects, Tableau automatically uses these embedded credentials to access the data. This is convenient and secure, as users don't need direct database access.

For extracts, "Embedded password" is often the best choice because it allows Tableau Server to refresh the extract automatically on a schedule without needing manual intervention.

Step 5: Finalize and Publish

Check the box for Update workbook to use the published data source. This is a handy feature that automatically switches your current workbook from using the local data source to using the newly published one on the server. If this is an extract, you can also define your connection type and refresh schedule now or do it later on the server.

Click the blue Publish button. Tableau will package and upload your data connection (and the extract file itself, if you created one) to the server.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 6: Set Your Extract Refresh Schedule (If Applicable)

If you published an extract, the data is static until you tell Tableau to refresh it. Navigate to your newly published data source on Tableau Server or Cloud. Find the Extract Refreshes tab, and click New Extract Refresh to set a schedule. You can set it to run daily, weekly, or hourly to keep your team's dashboards up to date automatically.

Final Thoughts

Getting into the habit of publishing your Tableau data sources is a powerful way to bring governance, efficiency, and reliability to your team's analytics workflow. It establishes a trustworthy foundation that simplifies report creation and ensures everyone makes decisions from the same set of consistent, accurate information.

While publishing data sources is a critical step, the initial process of connecting, cleaning, and centralizing data across different marketing and sales platforms can still be time-consuming. This is where we built Graphed to help. By connecting your sources like Google Analytics, Shopify, Facebook Ads, and Salesforce in one click, we automate the process of bringing all your data together into a single view. You can then use simple, conversational language to build dashboards, get answers, and keep your data refreshed in real-time without having to manually configure everything. If you're looking for an even faster path to a single source of truth, give Graphed a try.