Tableau Publishing to Tableau Server

Building a dashboard in Tableau Desktop is only half the job. Sharing it with colleagues, managers, or clients requires publishing. Tableau Server and Tableau Cloud host your workbooks online so anyone with access can view and interact with them — no Tableau Desktop installation needed.

Tableau Server vs Tableau Cloud

Both platforms host published workbooks and let viewers interact through a web browser or the Tableau Mobile app.

FeatureTableau ServerTableau Cloud
HostingYour organization's own serversTableau's cloud infrastructure
SetupRequires IT installation and maintenanceNo setup — ready immediately
ControlFull control over security and dataTableau manages infrastructure
Best ForLarge enterprises with strict data policiesTeams wanting a quick, managed solution

Publishing a Workbook from Tableau Desktop

  1. Sign in to Tableau Server or Tableau Cloud from Tableau Desktop: go to Server menu → Sign In
  2. Enter the server URL (e.g., https://yourcompany.tableau.com) and your credentials
  3. Go to Server menu → Publish Workbook
  4. A dialog opens asking for Project, Workbook Name, and options
  5. Choose a Project (a folder on the server) to organize the workbook
  6. Select which sheets and dashboards to publish
  7. Choose data source settings
  8. Click Publish

Projects and Site Structure

Tableau Server organizes content into Sites and Projects. A Site is a completely separate environment (like a tenant). Within a Site, Projects are folders that group related workbooks. Permissions apply at the Project level — a team gets access to their project's workbooks without seeing others.

Diagram: Server Content Structure

Tableau Server
└── Site: "MyCompany"
    ├── Project: "Sales Team"
    │   ├── Workbook: Q1 Sales Dashboard
    │   ├── Workbook: Regional Breakdown
    │   └── Workbook: Customer Analysis
    ├── Project: "Finance"
    │   ├── Workbook: Budget vs Actuals
    │   └── Workbook: Cost Center Report
    └── Project: "HR"
        └── Workbook: Headcount Dashboard

Publishing Data Sources Separately

Instead of embedding data inside each workbook, publish the data source independently. Multiple workbooks then connect to the same published data source. When the data source refreshes, all connected workbooks automatically show updated data. Go to Data menu → Publish Data Source → choose the source to publish.

Benefit of Published Data Sources

Without Published Data Source:
  Workbook A has its own copy of Sales data
  Workbook B has its own copy of Sales data
  Each workbook refreshes independently
  Risk of inconsistency between reports

With Published Data Source:
  One "Sales Data" source on the server
  Workbook A connects to it
  Workbook B connects to it
  One refresh → both workbooks update together
  Consistent numbers across all reports

Extract Refresh Schedules

Published extracts need regular refreshes to show current data. On Tableau Server or Tableau Cloud, right-click a published data source and select "Extract Refreshes." Set a schedule — hourly, daily, or weekly. The server automatically queries the original data source and rebuilds the extract at the scheduled time without any manual action.

Permissions and Access Control

Set permissions at the Project level or individual workbook level. Tableau has defined permission roles:

Permission RoleWhat the User Can Do
ViewerView and interact with published dashboards
ExplorerView, interact, and create new views from published data sources
CreatorFull access: publish workbooks, create data sources, manage content
Site AdministratorManage users, groups, projects, and all content on the site

Sharing Workbooks via URL

Every published view on Tableau Server has a unique URL. Copy and paste this URL to share a specific dashboard directly. The URL opens the dashboard in a browser — the viewer sees the live interactive dashboard without needing Tableau Desktop. Add filter parameters to the URL to share a pre-filtered view (e.g., ?Region=East appended to the URL pre-filters to the East region).

Embedding Dashboards

Tableau Server dashboards embed into internal portals, intranets, or web applications using an iframe tag. The embedded dashboard is fully interactive — viewers filter, click, and explore without leaving the parent application. Tableau also provides the Embedding API for more advanced integration with custom applications.

Row-Level Security

Row-Level Security (RLS) limits which data rows each viewer sees — automatically — based on their login identity. A regional manager sees only their region's data. A store owner sees only their store's data. Configure RLS by creating a security calculation that compares a data field (like Region or StoreID) against the logged-in user's username stored in a user filter or a security table on the server.

Row-Level Security Diagram

Published Dashboard: "National Sales Report"

Viewer: Alice (Region = East)
→ Dashboard automatically shows East data only

Viewer: Bob (Region = West)
→ Same dashboard automatically shows West data only

One workbook. Different data for different viewers.
No duplicate dashboards needed.

Version History and Workbook Revisions

Tableau Server stores previous versions of published workbooks. If a new publish introduces an error, restore an earlier version. Right-click a workbook in the server browser and select "Revision History." Choose any previous version and restore it with one click.

Summary

Publish workbooks from Tableau Desktop via the Server menu with a few clicks. Organize published content into Projects for team-based access control. Publish data sources independently so multiple workbooks share one consistent source. Schedule extract refreshes to keep data current automatically. Set permissions using Viewer, Explorer, and Creator roles. Share dashboards via URL or embed them into web portals. Implement Row-Level Security to deliver personalized data views from a single shared workbook. Version history protects against publishing mistakes.

Leave a Comment

Your email address will not be published. Required fields are marked *