Publishing to Tableau Server - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Tableau Server Publishing Permissions

Which of the following user roles on Tableau Server allows a user to publish new workbooks to a project?

A Publisher

B Viewer

C Explorer

D Interactor

💡 Hint

Think about the role that can interact with content and also publish new workbooks.

The Publisher role allows users to interact with content and publish new workbooks to projects where they have permission. Viewer cannot publish. Interactor is not a standard Tableau Server role. Explorer cannot publish.

🎯 Scenario

intermediate

Publishing a Workbook with Data Source Credentials

You want to publish a Tableau workbook to Tableau Server so that users can refresh the data without entering credentials. Which publishing option should you select?

A Publish with user prompt for credentials

B Publish with embedded credentials

C Publish as a packaged workbook (.twbx)

D Publish without credentials

💡 Hint

Think about how to allow automatic data refresh without user input.

Embedding credentials allows Tableau Server to use stored login information to refresh data sources automatically. Publishing without credentials requires users to enter them. Packaged workbooks bundle data but do not affect credentials. User prompt requires manual entry.

❓ dax_lod_result

advanced

Calculating Total Sales per Region Using LOD Expressions

Given a Tableau data source with sales data by region and date, which LOD expression correctly calculates total sales per region regardless of filters?

Tableau

{FIXED [Region] : SUM([Sales])}

A {EXCLUDE [Region] : SUM([Sales])}

B {INCLUDE [Region] : SUM([Sales])}

C {FIXED [Region] : SUM([Sales])}

D SUM([Sales])

💡 Hint

Consider which LOD expression fixes the calculation at the region level ignoring filters.

{FIXED [Region] : SUM([Sales])} calculates total sales per region ignoring other filters except context filters. INCLUDE adds detail, EXCLUDE removes detail, and plain SUM respects all filters.

🔧 Formula Fix

advanced

Troubleshooting Tableau Server Publishing Failure

You try to publish a workbook to Tableau Server but get an error: 'You do not have permission to publish to this project.' What is the most likely cause?

A You lack publishing permissions on the target project

B The server is offline

C The workbook contains unsupported data sources

D Your Tableau Desktop version is outdated

💡 Hint

Focus on the permission message in the error.

The error message clearly indicates a permissions issue. Outdated software or unsupported data sources usually cause different errors. Server offline would prevent connection, not permission denial.

❓ visualization

expert

Designing a Dashboard for Publishing to Tableau Server

You want to create a dashboard that clearly shows sales trends and allows users on Tableau Server to filter by region and date. Which design practice is best?

A Publish separate dashboards for each region

B Use multiple small charts with separate filters for each

C Use only text tables to simplify data

D Create a single dashboard with global filters for region and date

💡 Hint

Think about user experience and filter efficiency on Tableau Server.

A single dashboard with global filters provides a smooth user experience and efficient filtering. Multiple small charts with separate filters confuse users. Separate dashboards increase maintenance. Text tables alone do not show trends well.

Practice

1. What is the main purpose of publishing a workbook to Tableau Server?

easy

A. To share your dashboards with others securely and keep them updated

B. To delete your local workbook files automatically

C. To convert your workbook into a PDF file

D. To create a backup copy on your computer

Solution

1. Step 1: Understand publishing purpose

   Publishing to Tableau Server allows sharing dashboards with others easily.

2. Step 2: Identify key benefits

   It keeps dashboards updated and accessible anytime for authorized users.

3. Final Answer:

   To share your dashboards with others securely and keep them updated -> Option A

4. Quick Check:

   Publishing = Sharing + Updating [OK]

Hint: Publishing means sharing dashboards online for access [OK]

Common Mistakes:

• Thinking publishing deletes local files
• Confusing publishing with exporting to PDF
• Believing publishing only creates backups

2. Which of the following is the correct step to publish a workbook to Tableau Server from Tableau Desktop?

easy

A. Click 'Data' > 'Export to Server', then choose the server

B. Go to 'Edit' > 'Publish to Web', then enter server details

C. Right-click the dashboard and select 'Upload to Server'

D. Click 'File' > 'Publish Workbook', then select the server and project

Solution

1. Step 1: Locate publishing option in Tableau Desktop

   The correct menu path is 'File' then 'Publish Workbook'.

2. Step 2: Select server and project

   After clicking publish, you choose the Tableau Server and the project folder.

3. Final Answer:

   Click 'File' > 'Publish Workbook', then select the server and project -> Option D

4. Quick Check:

   Publish via File menu = Click 'File' > 'Publish Workbook', then select the server and project [OK]

Hint: Publishing is under File menu, not Data or Edit [OK]

Common Mistakes:

• Looking for publishing under Data or Edit menus
• Trying to upload by right-clicking dashboard
• Confusing 'Publish to Web' with Tableau Server publishing

3. After publishing a workbook to Tableau Server, which permission setting allows users only to view the dashboard but not edit it?

medium

A. Editor

B. Viewer

C. Publisher

D. Administrator

Solution

1. Step 1: Understand permission roles on Tableau Server

   Viewer role allows users to see dashboards but not make changes.

2. Step 2: Differentiate from other roles

   Editor can edit, Publisher can publish, Administrator manages server settings.

3. Final Answer:

   Viewer -> Option B

4. Quick Check:

   View-only permission = Viewer [OK]

Hint: View-only users have Viewer role, not Editor or Publisher [OK]

Common Mistakes:

• Choosing Editor which allows editing
• Confusing Publisher with Viewer
• Assuming Administrator is for viewing only

4. You tried to publish a workbook but received an error saying you lack permission. What is the most likely cause?

medium

A. Your Tableau Desktop version is outdated

B. Your workbook file is corrupted

C. You do not have publishing rights on the selected Tableau Server project

D. You forgot to save the workbook locally

Solution

1. Step 1: Analyze the permission error message

   The error about lacking permission usually means you cannot publish to that project.

2. Step 2: Rule out other causes

   File corruption or unsaved workbooks cause different errors; version issues usually warn differently.

3. Final Answer:

   You do not have publishing rights on the selected Tableau Server project -> Option C

4. Quick Check:

   Permission error = No publishing rights [OK]

Hint: Permission errors mean no publish rights on server project [OK]

Common Mistakes:

• Assuming file corruption causes permission errors
• Thinking unsaved workbooks cause permission errors
• Blaming Tableau Desktop version without checking permissions

5. You want to publish a dashboard that updates automatically every morning with new data. Which Tableau Server feature should you configure after publishing?

hard

A. Schedule a data extract refresh on Tableau Server

B. Manually republish the workbook daily

C. Set permissions to Editor for all users

D. Export the dashboard as a PDF every morning

Solution

1. Step 1: Identify the need for automatic data updates

   To keep data fresh, you need to refresh data extracts on Tableau Server automatically.

2. Step 2: Choose the correct Tableau Server feature

   Scheduling extract refreshes runs updates without manual republishing or exporting.

3. Final Answer:

   Schedule a data extract refresh on Tableau Server -> Option A

4. Quick Check:

   Auto update = Schedule extract refresh [OK]

Hint: Use scheduled extract refresh for automatic daily updates [OK]

Common Mistakes:

• Thinking manual republishing is automatic
• Confusing permissions with data refresh
• Exporting PDFs does not update data