How to Upload Workbook to Tableau Server
You’ve spent hours perfecting your Tableau workbook. The data is clean, the calculations are correct, and your dashboards are visually stunning - ready to provide serious insights to your team. The final hurdle is getting it out of your local Tableau Desktop and onto Tableau Server where everyone can access it. This guide covers how to publish your workbook, breaking down all the options so you can share your work confidently.
Before You Publish: A Quick Pre-Flight Checklist
Taking a few minutes to prepare your workbook before publishing can save you a lot of headaches later. Think of this as tidying up before company arrives.
1. Clean Up Your Worksheets and Dashboards
A clean workbook is easier for you and your team to navigate. Before you publish, quickly run through this checklist:
- Remove unused worksheets: Did you create scratchpad sheets for testing calculations? Hide them (right-click sheet > Hide) or delete them to reduce clutter.
- Polish your tooltips: Hovering over a data point should provide clear, useful information. Edit your tooltips to remove jargon and make them easy to read.
- Use descriptive names: Rename your worksheets, dashboards, and data sources with clear, intuitive titles. "Q3_Sales_Dashboard-v2_final" is less helpful than "Q3 Regional Sales Performance."
2. Understand Your Data Source Connection
This is arguably the most important preparation step. How your workbook connects to its data determines how it will behave on Tableau Server. You're likely using one of two connection types:
- Live Connection: Tableau queries your database directly. This is great for real-time dashboards where the data changes frequently. The major consideration is that Tableau Server needs to have a direct path to access that data source. If it's a database on a private network, you’ll need to make sure the server can reach it.
- Extract (.hyper file): An extract is a snapshot of your data stored within your Tableau workbook. This is fantastic for performance and for offline data sources (like an Excel file on your machine). You’ll need to set up a refresh schedule on the server to keep this data from becoming stale.
Check your connection type by looking at the data source icon in the "Data" pane on the left. Two cylinders mean it’s live, one cylinder with an arrow means it's an extract.
3. Consider Required Permissions
You don't need to configure everything just yet, but start thinking about who needs to see this workbook and what they should be allowed to do. Can anyone in the company view it? Is it sensitive data for only the finance team? Should users be able to download the underlying data or just view the charts?
Connecting to Tableau Server from Tableau Desktop
Before you can publish, you first need to sign into your company's Tableau Server from your Desktop application. If you haven't already, the process is straightforward.
- In Tableau Desktop, navigate to the top menu and click Server > Sign In...
- A dialog box will appear asking for your server's URL. This is usually something like
https://tableau.yourcompany.com. Paste or type it in and click Connect. - You'll then be prompted to enter your username and password for Tableau Server. Enter your credentials and click Sign In.
Once you're signed in, you'll stay connected, and the "Server" menu will show options like "Publish Workbook" instead of "Sign In."
Publishing Your Workbook: A Step-by-Step Walkthrough
With your workbook prepped and your connection to the server established, you’re ready to publish. Click Server > Publish Workbook... on the top menu. This opens the "Publish Workbook to Tableau Server" dialog box, which is where you'll configure everything.
Let’s walk through each section of this window.
1. General Settings
This section is for basic organization.
- Project: Think of Projects as folders on Tableau Server. Select the project where your workbook should live (e.g., "Marketing Analytics," "Executive Dashboards"). If you're not sure, your system admin can point you in the right direction.
- Name: This is the title of your workbook as it will appear on the server. By default, it uses your workbook’s file name, but you can change it to be more descriptive.
- Description: Add a brief description here. What is this workbook for? What questions does it answer? This context is extremely helpful for your colleagues.
2. Sheets
Here, you decide which parts of your workbook to publish. In the "Sheets" section, click the Edit button. You can choose to publish all your sheets or select only the specific dashboards, stories, and worksheets you want users to see. It’s a best practice to only publish the final, polished dashboards and hide the underlying worksheets used to build them.
3. Permissions
This setting controls who can access and interact with your workbook. By default, it's set to "Same as project." This means the workbook will inherit the permission rules of the project folder you're publishing it to. For most users, this is the easiest and best option to stick with.
If you need custom rules, you can click Edit to configure permissions on a per-user or per-group basis. For example, you could let "Marketing Managers" interact with filters but restrict "Marketing Interns" to View only.
4. Data Sources
This is where you'll configure the connection settings we discussed earlier.
- For Extracts: If you're using a data extract, you'll see options to either Embed in workbook or Publish separately.
- For Live Connections: You need to tell Tableau Server how to authenticate with the database. You'll likely see options like:
If you have multiple data sources, you'll configure each one individually in this section.
5. Publishing Options
These are final touches that control the user experience.
- Show sheets as tabs: If your workbook has multiple dashboards, checking this box will display them as tabs across the top of the view, making navigation much simpler for your users. It’s highly recommended to keep this checked.
- Show selections: Allows users to see highlighted selections on a viz. It’s situationally useful, and the default is usually fine.
- Include external files: If your workbook uses external files, like a custom background image or data from a non-server location, check this box. Tableau will bundle a copy of these files with the workbook on the server. When in doubt, leave it checked.
Hit 'Publish'!
Once you’ve configured everything to your satisfaction, click the big blue Publish button at the bottom. Tableau will then package up your workbook and upload it to the server. You'll see a success message when it's done, which usually includes a link straight to your newly published workbook.
After Publishing: Verification and Next Steps
Don’t close up shop just yet. Your final steps are to make sure everything works as expected and set up any necessary automation.
Check Your Work
Click the link from the success pop-up or navigate to the workbook on Tableau Server. Do the dashboards look right? Are all the filters and buttons working? Interact with it as if you were a first-time user to catch any issues.
Set a Refresh Schedule (for Extracts)
If you published a workbook with an extracted data source, you need to tell the server when to update that data. On Tableau Server, navigate to your workbook, find the “Data Sources” tab, click the three dots (...) next to your data source, and select Refresh Schedules. Here, you can choose a schedule (e.g., "Daily at 6 AM") to automatically refresh your extract so your data never gets stale.
Share the Link
Now, you can grab the URL from your workbook on Tableau Server and share it with your team. They can finally see and interact with all the hard work you’ve put in.
Final Thoughts
Publishing your dashboard to Tableau Server transforms it from a personal analysis into a shared resource that can drive decisions. By methodically going through the preparation, connection, and publishing steps - paying close attention to your data sources - you can make sharing your insights a smooth and repeatable process.
While publishing-ready dashboards in tools like Tableau are powerful, the process of manually preparing, publishing, and configuring them still takes time and technical know-how. This is why we created Graphed, target="_blank" rel="noopener"). We wanted to eliminate the friction between having data and getting answers. Instead of navigating menus and dialog boxes, you can just connect your marketing and sales platforms (like Google Analytics, Shopify, or Salesforce) in a few clicks and ask in plain English, "Show me my campaign ROI by channel as a bar chart.” We’ll instantly build a live, shareable dashboard for you - no publishing process required.
Related Articles
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.
How to Create a Photo Album in Meta Business Suite
How to create a photo album in Meta Business Suite — step-by-step guide to organizing Facebook and Instagram photos into albums for your business page.