11.2 Publishing Workbooks, Data Sources & Flows

Salesforce Certified Tableau Data Analyst Exam

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Connecting to Data & The Logical Data Model

1.1 Data Connections: Live Connections vs. Hyper Extracts 1.2 The Tableau Data Model: Relationships vs. Physical Joins 1.3 Combining Data: Data Blending vs. Cross-Database Joins

2 Chapter 2: Tableau Prep Builder & Data Wrangling

2.1 Tableau Prep Architecture & Data Cleaning 2.2 Reshaping Data in Prep: Pivots, Splits & Wildcard Unions 2.3 Joins, Aggregations & Output Destinations in Prep

3 Chapter 3: Data Quality, Metadata & Field Configuration

3.1 Data Types, Roles, Organization & Default Properties 3.2 In-Desktop Data Cleaning: Splits, Data Interpreter & Source Replacement 3.3 Managing Slowly Changing Dimensions & Data Quality Warnings

4 Chapter 4: Tableau Fundamentals & Calculations

4.1 Dimensions vs. Measures & Discrete vs. Continuous 4.2 Mastering Dates: Discrete Date Parts vs. Continuous Date Truncations 4.3 Calculations: Logic, Strings, Nulls & Type Conversion 4.4 Aggregation Rules, Granularity & Dealing with the Asterisk (ATTR)

5 Chapter 5: Level of Detail (LOD) Expressions

5.1 Level of Detail Architecture & Scoping Syntax 5.2 FIXED LOD Expressions: Scoping & Baseline Benchmarks 5.3 INCLUDE & EXCLUDE LOD Expressions: Dynamic Granularity 5.4 Real-World LOD Patterns: Cohorts, First/Last Dates & Binning

6 Chapter 6: Table Calculations & Directionality

6.1 Table Calculation Mechanics: Addressing vs. Partitioning 6.2 Essential Table Calculations: Running, Window & Percent of Total 6.3 Navigation & Ranking Functions: LOOKUP, INDEX & RANK 6.4 Secondary & Nested Table Calculations: Multi-Level Scoping

7 Chapter 7: Statistical Analytics, Filtering & Order of Operations

7.1 The Tableau Order of Operations: From Extract to Display Filters 7.2 Sets, Set Actions & Combined Sets vs. Groups 7.3 Parameters, Parameter Actions & Dynamic What-If Analysis 7.4 Analytics Pane: Totals, References, Trends & Forecasts

8 Chapter 8: Chart Types & Comparative Visualizations

8.1 Comparison Visualizations: Bar Charts, Highlight Tables & Bullet Graphs 8.2 Part-to-Whole & Correlation Charts: Treemaps, Scatter Plots & Bubbles 8.3 Trend & Distribution Visualizations: Dual-Axis, Combos & Histograms

9 Chapter 9: Advanced Visualizations & Spatial Analysis

9.1 Specialized Visualizations: Waterfall, Gantt, Sparklines & Bump Charts 9.2 Spatial Data & Mapping: Geographic Layers & Spatial Functions 9.3 Visual Polish: Custom Palettes, Annotations & Viz in Tooltip

10 Chapter 10: Dashboard Design & Interactive Actions

10.1 Dashboard Layout, Devices & Visibility 10.2 Filter, Highlight & URL Actions 10.3 Advanced Interactivity: Parameter, Set & Navigation Actions 10.4 Stories & Visual Storytelling: Sequencing Analytical Narratives

11 Chapter 11: Tableau Server & Cloud: Architecture & Publishing

11.1 Tableau Server & Cloud: Sites, Projects, Roles & Permissions 11.2 Publishing Workbooks, Data Sources & Flows

12 Chapter 12: Data Governance, Security & Operations

12.1 Certification, Data Quality, Lineage & Permissions 12.2 Row-Level Security, Schedules, Subscriptions & Alerts

11.2 Publishing Workbooks, Data Sources & Flows

Key Takeaways Explain This Topic AI

Show Sheets as Tabs provides navigation and affects whether permissions operate at workbook or view level.

Published data sources centralize reusable metadata and connections; embedded sources remain workbook-specific.

Unattended refreshes need usable stored credentials or tokens and a valid network path.

Publishing a flow output does not automatically certify it; certification is a separate authorized governance action.

Tableau Server defaults to 25 retained revisions, while Tableau Cloud retains up to 10.

Last updated: September 2026

11.2 Publishing Workbooks, Data Sources & Flows

Publishing moves content from an authoring environment into Tableau Server or Tableau Cloud so people can discover, view, edit, refresh, and govern it. Before publishing, remove unused sheets and fields where appropriate, confirm names and descriptions, test permissions with representative groups, validate credentials, and decide whether connections should be embedded in a workbook or managed as published data sources.

Publishing a workbook

From Tableau Desktop, choose Server > Publish Workbook, select the site and project, name the workbook, choose which sheets to publish, configure permissions, and review data-source authentication. Hidden worksheets that feed dashboards normally remain available to the workbook even when not exposed as navigation destinations. Test the published result because fonts, extensions, credentials, and network reachability can differ from Desktop.

The Show Sheets as Tabs setting provides workbook navigation and changes permission granularity. When tabs are shown, views in the workbook use workbook-level permissions. When tabs are hidden and the project allows customizable permissions, views can be assigned independent permissions. Tabs should be selected for navigation and permission intent—not on an unsupported claim that they create a unified cache or guarantee instant actions. Navigation objects and dashboard actions can guide users to another sheet whether visible tabs are part of the design or not.

Embedded and published data sources

An embedded data source travels with a workbook and is managed in that workbook. It is practical for a self-contained analysis, but duplicated embedded definitions can drift across many workbooks. A published data source is a separately managed asset that multiple workbooks can connect to. Centralized calculations, metadata, extracts, and connection information can then be updated once for downstream consumers.

Publishing a data source requires a target project, permissions, authentication choices, and—when it is an extract—an appropriate refresh plan. Downstream authors need Connect permission. Replacing or overwriting a shared source can affect many workbooks, so perform impact review, preserve compatible field names and types, and test representative dependents.

Authorized Creator users can edit certain published data sources in the browser from the data-source page. The browser scratchpad supports metadata work such as renaming fields, creating folders and hierarchies, changing aliases, and creating calculations before publishing changes. Desktop workflows can also create a local copy or connect and publish changes when supported. There is no generic Save to All Connected Workbooks command inside one downstream workbook.

Authentication and refreshes

For a live connection, choose an authentication mode that meets the source's security and usability requirements. Prompting each viewer can preserve per-user database identity. Embedded credentials can support shared access but must be permitted and governed. OAuth may provide managed tokens for supported services.

An unattended extract refresh cannot stop to ask a person for a password. If the published connection requires interactive prompting and no usable stored credential or token is available, the background refresh fails. Validate scheduled refreshes with the server or cloud environment's actual network route. Tableau Bridge may be needed for Tableau Cloud to reach supported private-network data.

Publishing flows

Tableau Prep Builder flows can be published when the environment and licenses support them. A flow contains input, cleaning, transformation, and output steps; the .tfl or packaged .tflx definition is distinct from the output data. Published flows can be run manually or through supported scheduling capabilities. A flow output might write to a file, a database table, or a published data source depending on the configured connector and deployment. Certification is a separate governance action performed by an authorized user; publishing an output does not automatically certify it.

Downloads, exports, and sharing

Viewers can share a link to content they are allowed to see. Depending on site configuration and permissions, they may export an image, PDF, PowerPoint, crosstab, summary data, or underlying data, or download a workbook. These are separate capabilities. Granting View does not automatically mean a user may download full data or the workbook.

A custom view saves filter, sort, selection, and zoom state for the existing published view. It does not make a new workbook or alter the source data. Subscriptions deliver a view on a schedule or after a refresh when supported. Data-driven alerts notify recipients when a continuous measure crosses a condition. Select the feature that matches the request: link for access, export for a static artifact, custom view for saved state, subscription for recurring delivery, or alert for a threshold.

Revisions and rollback

Revision history can retain prior workbook and data-source revisions when enabled. Tableau Server uses a default maximum of 25 revisions unless an administrator changes it. Tableau Cloud retains up to 10 revisions. A revision restores content, not necessarily every external database state or credential. Confirm the platform, retention setting, and dependencies before relying on rollback.

Publication checklist

Validate workbook calculations, filters, actions, device layouts, and accessibility.

Choose embedded or published sources based on reuse and governance.

Select the correct project and verify group permissions and tab semantics.

Configure credentials appropriate for interactive views and unattended refreshes.

Publish only intended sheets and supply useful descriptions and ownership.

Test as a representative viewer, author, and refresh service.

Confirm download, export, custom-view, subscription, and alert behavior matches policy.

Record dependencies and monitor the first scheduled job.

Publishing is complete only when the hosted asset renders, refreshes, and enforces access as intended.