How to Activate Tableau Workbook

Activating a Tableau workbook means bringing it to life - moving it from a static file on your computer to an interactive, shareable dashboard that your team can use. This article will show you exactly how to publish your work from Tableau Desktop, making it accessible and dynamic for others through Tableau Server or Tableau Online.

What Does "Activating" a Workbook Mean?

While "activate" isn't an official term in Tableau's documentation, it perfectly describes the goal: making a workbook fully functional and accessible to your audience. An unactivated workbook might just be a .twb or .twbx file on your hard drive, a simple screenshot, or a static PDF. You can't interact with it unless you have Tableau Desktop installed.

An activated workbook, on the other hand, is one that has been published to a central location like Tableau Server or Tableau Online. Once published, anyone with the right permissions can:

• View and interact with dashboards in a web browser.
• Filter, sort, and drill down into the data live.
• Receive automatic data refreshes, ensuring the visuals are always up to date.
• Share insights easily with a URL, just like any other webpage.

The process of "activating" a workbook is technically called publishing. Let's walk through how to do it step by step.

Step 1: Prepare Your Workbook for Publishing

Before you publish, a little housekeeping goes a long way. A clean and optimized workbook will perform better and provide a much better experience for your end-users. Think of this as getting your report ready for its big debut.

Clean Up Your Sheets and Dashboards

Your local workbook file might contain lots of "scratchpad" worksheets, old test visuals, and duplicate dashboards. These are helpful during development but create clutter when published.

• Hide Unused Sheets: Right-click the tab for any worksheet that you don't want to show to end-users and select "Hide." You should only publish the final, polished dashboards and stories.
• Give Clear Names: Double-click the tab for each dashboard and worksheet to give them descriptive names (e.g., "Monthly Sales Performance" instead of "Dashboard 1"). This makes navigation much easier for others.
• Add Explanations: Use text boxes on your dashboards to add titles, short explanations of charts, or definitions of complex metrics. Assume the person viewing it doesn't have your level of context.

Choose Between a Live Connection and an Extract

Your workbook's connection to its data source is critical. You have two main options:

• A Live Connection queries the data source directly every time a user interacts with the dashboard. This is great for real-time data where a few seconds of delay is acceptable, like a monitoring dashboard for a manufacturing line. However, it can be slow if the underlying database is slow or the query is complex.
• An Extract (a .hyper file) is a snapshot of your data that is stored inside the workbook or on the Tableau Server. Extracts are usually much faster, as Tableau doesn't have to go back to the original database for every action. This is the best choice for most dashboards, especially when performance is a priority. After you publish, you can schedule the extract to refresh automatically (e.g., every morning at 8 AM).

To choose your connection type, go to the "Data Source" tab in Tableau Desktop. In the top right corner, you can select between Live and Extract. If you choose Extract, it's a good idea to create it before publishing.

Step 2: Publish the Workbook to Tableau Server or Online

Once your workbook is polished and you've chosen your connection type, you're ready to publish. This is done directly from Tableau Desktop.

Connect to Your Server

1. From the top menu, go to Server > Sign In.
2. A dialog box will appear asking for the server URL. If you're using Tableau Online, it will look something like https://10ax.online.tableau.com. If your company has its own Tableau Server, your IT admin will provide the URL. Enter it and click "Connect."
3. You'll then be prompted to enter your username and password for the server.

Once you are signed in, you will remain connected, and the "Server" menu options will become active.

Navigate the Publishing Options

With your workbook open, go to Server > Publish Workbook. This will open the "Publish Workbook" dialog box, which contains all the settings for your "activation." Let's break down each option.

1. General Settings

• Project: Projects in Tableau are like folders used to organize content. Choose the project where you want your workbook to live. Your administrator usually sets up projects for different teams or departments (e.g., "Marketing," "Sales Reports," "Executive KPIs").
• Name: This will be the public name of your workbook on the server. By default, it uses the filename, but you can change it to something more user-friendly.
• Description & Tags: Add a short description of what the workbook shows. Tags help people find your workbook when they search the server, so add relevant keywords like "sales," "q3," "finance," or "campaign."

2. Sheets

Here, you'll see a list of every dashboard, worksheet, and story in your file. By default, Tableau might select all of them. To avoid clutter, click the "Edit" button and select ONLY the dashboards and stories you want end-users to see. Remember all those "scratchpad" worksheets you hid? Make sure they are un-selected here so they don’t show up online.

3. Permissions

Permissions control who can see, interact with, edit, or download your workbook. In most organizations, permissions are managed at the Project level by an administrator. It's usually best to leave this setting as-is unless you've been instructed otherwise. If you change a setting here, it will override the project-level defaults, which can sometimes cause confusion.

4. Data Sources

This is arguably the most important section for keeping your dashboard's data fresh.

• Publish Separately vs. Embedded: You can either embed the data source connection within the workbook or publish the data source separately. For a single dashboard, embedding is fine. If you plan to use the same data source for multiple workbooks, publishing it separately is more efficient.
• Authentication: This tells Tableau Server how to access the underlying data after the workbook is published.

For a daily sales report that pulls from a SQL database, the most common setup is an Extract with an Embedded password for authentication.

5. Finalize and Publish

Under "More Options," you can control a few final details, such as "Show sheets as tabs." This displays the selected sheets as tabs at the top of the browser view, which can be useful for navigation.

Once you are happy with your settings, click the blue Publish button at the bottom. Tableau Desktop will package your workbook and upload it to the server. When it's finished, a new browser tab will typically open, showing you your newly "activated" workbook!

Step 3: Verify, Share, and Schedule Your Workbook

Publishing isn't the final step. Now you need to make sure everything works as expected and set it up for ongoing success.

Test the Interactive Features

In the browser window, click around your dashboard. Test the filters, tooltips, and any other interactive elements. Does everything work as it did in Tableau Desktop? This simple check can catch issues, like a missing image or a broken URL action.

Set up a Refresh Schedule (for Extracts)

If you published a workbook with a data extract, the data is static until you tell Tableau Server when to refresh it. To do this:

1. Navigate to your workbook on Tableau Online or Server.
2. At the top, you'll see tabs for "Views," "Data Sources," etc. Click on Data Sources.
3. Click the three dots (...) next to your data source and select Refresh Schedules.
4. From here, you can choose a predefined schedule (e.g., "Daily at 7 AM") or create a new one. This ensures your team is always looking at the latest data without any manual effort.

Share the Link

Your workbook is now a living report! To share it, simply click the "Share" icon at the top of the dashboard. You can copy a direct link or get an embed code to place the dashboard directly into a web page, SharePoint site, or internal portal.

Final Thoughts

Activating a Tableau workbook is the crucial final step that turns your analysis into a valuable asset for your team. By carefully preparing your workbook, configuring the publishing settings correctly, and setting up a refresh schedule, you create a reliable, interactive resource that empowers your team with fresh data.

The entire process of building dashboards in tools like Tableau, from connecting data to organizing visuals and managing publishing settings, contains dozens of small but crucial steps. We built Graphed because we believe getting insights shouldn't require such a steep learning curve. We connect directly to your marketing and sales platforms and allow you to build real-time, shareable dashboards just by describing what you want. Turning hours of work into a 30-second conversation!