Tableau Publishing and Sharing
Learn how to publish Tableau workbooks and dashboards to Tableau Server and Tableau Cloud, manage permissions, share visualizations, and schedule data refreshes.
1. Introduction to Tableau Publishing and Sharing
Tableau Publishing and Sharing is the process of making Tableau workbooks, dashboards, and data sources available to other users through a centralized platform.
After developing a workbook in Tableau Desktop, developers can publish it to Tableau Server or Tableau Cloud. Authorized users can then access dashboards using a web browser or supported Tableau applications.
Why Is Publishing Important?
- Allows users to access dashboards from different locations.
- Provides centralized access to reports and workbooks.
- Supports collaboration between teams.
- Helps organizations distribute business insights.
- Provides centralized permission management.
- Supports scheduled data refreshes for published content.
2. Tableau Publishing Platforms
Tableau provides different platforms for publishing and sharing analytical content. Two commonly used platforms are Tableau Server and Tableau Cloud.
2.1 Tableau Server
Tableau Server is an enterprise platform that organizations can deploy and manage within their own infrastructure or supported hosting environment.
- Provides centralized workbook and data source management.
- Supports user authentication and permissions.
- Allows teams to share dashboards securely.
- Supports extract refresh schedules.
- Provides administrative and monitoring capabilities.
2.2 Tableau Cloud
Tableau Cloud is a hosted analytics platform managed by Tableau. Organizations can publish content without maintaining their own Tableau Server infrastructure.
- Provides hosted access to Tableau content.
- Supports sharing dashboards with authorized users.
- Provides content and permission management.
- Supports supported data refresh and connectivity options.
- Reduces the need to manage underlying server infrastructure.
| Feature | Tableau Server | Tableau Cloud |
|---|---|---|
| Hosting | Managed by the organization. | Hosted and managed by Tableau. |
| Infrastructure | Organization manages infrastructure. | Tableau manages the cloud platform. |
| Administration | Server administration is required. | Platform infrastructure administration is handled by Tableau. |
| Content Sharing | Supported through permissions and projects. | Supported through permissions and projects. |
| Data Connectivity | Depends on deployment and configuration. | Depends on supported connectors and connectivity configuration. |
3. Tableau Publishing Architecture
Tableau publishing involves transferring a workbook from the development environment to a centralized Tableau platform. Users access the published content according to their permissions.
Publishing Workflow
- Create a workbook in Tableau Desktop.
- Connect and prepare the required data.
- Build worksheets and dashboards.
- Save and validate the workbook.
- Connect to Tableau Server or Tableau Cloud.
- Select the destination project.
- Publish the workbook.
- Configure permissions and verify user access.
4. How to Publish a Tableau Workbook
Tableau Desktop provides options to publish workbooks to Tableau Server or Tableau Cloud. The publishing process makes the workbook available on the selected platform.
Step-by-Step Publishing Process
- Open Tableau Desktop.
- Open the workbook that you want to publish.
- Review worksheets, dashboards, and data connections.
- Open the Server menu.
- Select the appropriate publishing option.
- Sign in to the Tableau Server or Tableau Cloud site.
- Choose the destination project.
- Enter the workbook name.
- Configure the data source and extract options as required.
- Review permissions and publishing settings.
- Click Publish.
Important Publishing Options
| Option | Purpose |
|---|---|
| Workbook Name | Defines the name of the published workbook. |
| Project | Selects the destination project. |
| Data Source | Controls how the workbook connects to its data. |
| Extract | Allows extract-related publishing and refresh configuration. |
| Permissions | Controls access for users and groups. |
5. Understanding Tableau Projects
Projects are containers used to organize Tableau content. They help administrators and teams manage workbooks, published data sources, and other content in a structured way.
Benefits of Projects
- Organize workbooks by department or business function.
- Group related dashboards together.
- Apply permissions at the project level.
- Make content easier to discover.
- Support centralized content administration.
Example: Organization Project Structure
Organization
|
|-- Sales Project
| |-- Sales Dashboard
| |-- Revenue Analysis
| |-- Regional Performance
|
|-- Finance Project
| |-- Financial Summary
| |-- Expense Analysis
|
|-- HR Project
|-- Employee Dashboard
|-- Recruitment Analysis
This structure separates dashboards according to business departments and makes content easier to manage.
6. Sharing Tableau Dashboards
After publishing a dashboard, authorized users can access it through Tableau Server or Tableau Cloud. Sharing methods depend on the platform configuration and organization policy.
Common Sharing Methods
- Share a dashboard link with authorized users.
- Share content through a Tableau project.
- Grant access to specific users or groups.
- Embed views in supported applications or web pages.
- Export views to supported file formats when permitted.
Sharing Through a Link
- Open the published dashboard.
- Locate the Share option.
- Copy the dashboard link.
- Send the link to the intended users.
- Ensure that recipients have the required permissions.
7. Tableau Permissions
Permissions control what users can do with Tableau content. Administrators and content owners can assign capabilities according to the responsibilities of different users.
Common Permission Capabilities
| Capability | Description |
|---|---|
| View | Allows users to view published content. |
| Explore | Allows permitted users to interact with content and explore data. |
| Download Image / PDF | Allows supported image or PDF downloads. |
| Download Full Data | Allows access to underlying data when permitted. |
| Download Workbook | Allows downloading the workbook when permitted. |
| Web Edit | Allows editing content through supported web authoring features. |
| Save | Allows users to save changes or content where permitted. |
8. Managing Users and Groups
Tableau administrators can manage users and organize them into groups. Groups simplify permission management when many users require similar access.
Users
A user represents an individual account that can access Tableau Server or Tableau Cloud according to assigned site role and permissions.
Groups
A group is a collection of users. Instead of assigning identical permissions to every user individually, administrators can assign permissions to a group.
Example: Department-Based Groups
| Group | Members | Typical Access |
|---|---|---|
| Sales Team | Sales employees | Sales dashboards |
| Finance Team | Finance employees | Financial reports |
| HR Team | HR employees | Employee dashboards |
| Administrators | Authorized administrators | Administrative capabilities |
9. Understanding Tableau Site Roles
Site roles determine the maximum level of access a user can have on a Tableau site. They help administrators control which activities users are allowed to perform.
Common Site Roles
| Site Role | General Purpose |
|---|---|
| Creator | Can create and publish content, subject to permissions. |
| Explorer | Can explore and interact with content according to permissions. |
| Viewer | Can view and interact with permitted published content. |
| Site Administrator Creator | Provides site administration capabilities along with Creator-level capabilities. |
| Site Administrator Explorer | Provides site administration capabilities with Explorer-level capabilities. |
| Unlicensed | Does not provide normal licensed access to the site. |
10. Permission Management Workflow
Effective permission management ensures that users can access the content they need without receiving unnecessary privileges.
Recommended Permission Practices
- Assign permissions according to business requirements.
- Use groups for users with similar access needs.
- Provide only the required capabilities.
- Review permissions regularly.
- Avoid granting administrative access unnecessarily.
- Test access using appropriate user accounts.
11. Scheduling Extract Refreshes
Published Tableau workbooks may use extracts instead of Live connections. Extract refresh schedules help keep published data updated according to business requirements.
What Is Extract Refresh?
An extract refresh updates the stored Tableau extract using data from its connected source. Depending on the configuration, the refresh may be full or incremental.
Full Refresh
A full refresh rebuilds the extract using the current source data included by the configured connection and filters.
Incremental Refresh
An incremental refresh adds new records based on a selected field and supported refresh configuration. It can reduce refresh workload when the source data is suitable.
| Refresh Type | Description | Suitable Scenario |
|---|---|---|
| Full Refresh | Rebuilds the extract from the source. | When historical records may change. |
| Incremental Refresh | Adds new records using a selected field. | When data is primarily append-only. |
12. Creating an Extract Refresh Schedule
Tableau Server and Tableau Cloud provide scheduling capabilities for supported extract refresh workflows. Administrators can configure refresh frequency and monitor refresh status.
General Steps
- Sign in to Tableau Server or Tableau Cloud.
- Open the required published workbook or data source.
- Locate the extract refresh or schedule settings.
- Select the required refresh type.
- Choose an available schedule.
- Configure credentials or connection requirements.
- Save the refresh configuration.
- Monitor refresh history and job status.
Example: Business Refresh Schedule
| Dashboard | Refresh Frequency | Business Requirement |
|---|---|---|
| Daily Sales | Daily | Review updated daily sales. |
| Monthly Finance | Monthly | Review finalized monthly figures. |
| Inventory | Several times per day | Monitor stock changes. |
| Employee Summary | Weekly | Review periodic HR information. |
13. Publishing Data Sources
Tableau allows developers to publish data sources separately from workbooks. A published data source can be reused by multiple workbooks, helping teams maintain a consistent data model.
Benefits of Published Data Sources
- Allows multiple workbooks to reuse a common data source.
- Reduces repeated data connection setup.
- Supports centralized data source management.
- Helps maintain consistent definitions and calculations.
- Allows administrators to manage access centrally.
Publishing Data Source Steps
- Open the required data source in Tableau Desktop.
- Verify fields, data types, and relationships.
- Open the Server menu.
- Select the publishing option for the data source.
- Choose the destination project.
- Configure authentication and connection details.
- Publish the data source.
- Use the published data source in supported workbooks.
14. Embedding Tableau Dashboards
Embedding allows Tableau views to be displayed within supported external websites or applications. It helps organizations integrate analytics into their existing business workflows.
Common Embedding Scenarios
- Displaying sales dashboards inside a business portal.
- Showing financial analytics in an internal application.
- Integrating reports into a company intranet.
- Providing analytics within a supported web application.
Embedding Considerations
- Configure appropriate authentication.
- Ensure that users have permission to view the content.
- Use supported embedding methods and APIs.
- Follow the organization's security requirements.
- Test the embedded view across supported browsers.
15. Exporting and Downloading Tableau Content
Tableau provides options for exporting or downloading supported views and workbook content. Available options depend on user permissions, content type, and platform settings.
| Export Option | Purpose |
|---|---|
| Creates a document version of a supported view. | |
| Image | Exports a supported visualization as an image. |
| Crosstab | Exports supported tabular data. |
| Data | Provides data download options when permitted. |
| Workbook | Allows workbook downloading when permitted. |
16. Complete Publishing and Sharing Workflow
A proper publishing workflow includes workbook development, validation, publishing, permission configuration, and ongoing maintenance.
17. Security Best Practices for Tableau Sharing
Tableau dashboards may contain confidential business information. Proper security configuration is essential when publishing and sharing analytical content.
Security Best Practices
- Use authenticated access for protected dashboards.
- Assign permissions based on job responsibilities.
- Use groups to manage access efficiently.
- Review workbook and data source permissions regularly.
- Restrict downloads of sensitive data where required.
- Use row-level security when users should see only specific records.
- Follow organizational data governance policies.
- Review embedded dashboard authentication settings.
Understanding Row-Level Security
Row-level security restricts which records a user can access. For example, a regional manager may be allowed to view only sales records belonging to their region.
Example: Regional Sales Access
| User | Assigned Region | Expected Data Access |
|---|---|---|
| Manager A | North | North region records |
| Manager B | South | South region records |
| Manager C | West | West region records |
18. Common Publishing and Sharing Problems
| Problem | Possible Cause | Recommended Solution |
|---|---|---|
| Workbook publishing fails | Connection, permission, or publishing issue. | Verify server connection and publishing permissions. |
| User cannot access dashboard | Missing permissions or authentication issue. | Review user access and site membership. |
| Extract refresh fails | Credential or data source connectivity issue. | Verify credentials and source connectivity. |
| Dashboard displays outdated data | Extract has not been refreshed. | Review refresh schedule and job status. |
| Embedded view does not load | Authentication or embedding configuration issue. | Review authentication and embedding setup. |
| Download option is unavailable | Download capability is restricted. | Review permissions and site settings. |
| Published data source is unavailable | Access or connection configuration issue. | Verify project permissions and data source connection. |
19. Practical Exercise: Publish and Share a Sales Dashboard
In this exercise, create a sales dashboard in Tableau Desktop and publish it to Tableau Server or Tableau Cloud.
Exercise Requirements
- Create a sales dashboard using a sample sales dataset.
- Add sales, profit, category, and regional visualizations.
- Validate dashboard filters and interactions.
- Connect to your Tableau publishing platform.
- Create or select a suitable project.
- Publish the workbook.
- Configure permissions for the intended users.
- Share the dashboard link with authorized users.
- Configure an extract refresh schedule if required.
- Verify dashboard access using an appropriate test account.
Expected Result
20. Interview Questions and Answers
Q1. What is Tableau Publishing?
Tableau Publishing is the process of uploading workbooks, dashboards, or data sources to Tableau Server or Tableau Cloud so authorized users can access them.
Q2. What is Tableau Server?
Tableau Server is an enterprise platform used to host, manage, and share Tableau content within an organization's configured infrastructure.
Q3. What is Tableau Cloud?
Tableau Cloud is a hosted analytics platform that allows organizations to publish, manage, and share Tableau content without managing their own Tableau Server infrastructure.
Q4. What is a Tableau Project?
A project is a container used to organize Tableau content such as workbooks and published data sources.
Q5. What are Tableau Permissions?
Permissions define what actions users can perform on Tableau content, such as viewing, exploring, downloading, or editing, depending on the assigned capabilities.
Q6. What is a Tableau Site Role?
A site role defines the maximum level of access a user can have on a Tableau site.
Q7. What is an Extract Refresh Schedule?
An extract refresh schedule defines when a published Tableau extract should be updated from its data source.
Q8. What is the difference between Full and Incremental Refresh?
A full refresh rebuilds the extract, while an incremental refresh adds new records using a selected field and supported refresh configuration.
Q9. What is Row-Level Security?
Row-level security restricts data access so users can view only the records they are authorized to see.
Q10. Can a dashboard URL be shared with any user?
A URL can be shared, but users still need appropriate authentication and permissions to access protected content.
Summary
Tableau Publishing and Sharing allows organizations to distribute workbooks, dashboards, and published data sources through Tableau Server and Tableau Cloud. Developers can publish workbooks, organize content into projects, manage users and groups, configure site roles and permissions, and share dashboards with authorized users. Extract refresh schedules help maintain updated data, while embedding and export options support different business requirements. Security practices such as authenticated access, permission management, and row-level security help protect sensitive information. A complete publishing workflow includes workbook development, validation, publishing, access configuration, sharing, and ongoing monitoring.