Publishing to Tableau Server - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to publish a workbook to Tableau Server using Tableau's REST API.

Tableau

server = TableauServerConnection(server='https://mytableauserver.com', username='user', password='pass')
server.[1]()

Drag options to blanks, or click blank then click option'

Adisconnect

Bconnect

Cpublish

Dlogout

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to publish before connecting.

Calling disconnect instead of connect.

You must first connect to the Tableau Server before performing any actions like publishing.

2fill in blank

medium

Complete the code to publish a workbook file named 'Sales.twbx' to a specific project on Tableau Server.

Tableau

server.publish_workbook(workbook_file='Sales.twbx', project_id=[1], mode='overwrite')

Drag options to blanks, or click blank then click option'

A'all_projects'

B'default'

C'67890'

D'12345'

Attempts:

3 left

💡 Hint

Common Mistakes

Using project names instead of IDs.

Using invalid or placeholder strings.

The project_id must be the unique identifier of the target project on Tableau Server, such as '67890'.

3fill in blank

hard

Fix the error in the code to properly publish a workbook with overwrite mode.

Tableau

server.publish_workbook(workbook_file='Dashboard.twbx', project_id='54321', mode=[1])

Drag options to blanks, or click blank then click option'

A'overwrite'

B'append'

C'replace'

D'Overwrite'

Attempts:

3 left

💡 Hint

Common Mistakes

Using uppercase 'Overwrite' causes errors.

Using unsupported modes like 'replace'.

The mode parameter is case-sensitive and must be 'overwrite' in lowercase to work correctly.

4fill in blank

hard

Fill both blanks to set permissions for a published workbook to allow viewing and editing.

Tableau

permissions = {
  'view': [1],
  'edit': [2]
}

Drag options to blanks, or click blank then click option'

A'Allow'

B'Deny'

C'Read'

D'Write'

Attempts:

3 left

💡 Hint

Common Mistakes

Setting permissions to 'Deny' blocks access.

Confusing 'Read' with 'Allow' for editing.

To allow users to view and edit, set 'view' permission to 'Allow' and 'edit' permission to 'Write'.

5fill in blank

hard

Fill all three blanks to disconnect from Tableau Server and confirm the session is closed.

Tableau

server.[1]()
if not server.[2]:
    print('Session [3] closed successfully')

Drag options to blanks, or click blank then click option'

Adisconnect

Bis_connected

Chas_been

Dis_active

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong method names like 'logout'.

Checking wrong properties for connection status.

Call disconnect() to end the session, check is_connected property, and confirm with message that session has_been closed.

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