Repository navigation
How to publish a workbook with different data sources #446
Description
I am using TSC to publish a workbook to the Tableau server.
My sample workbook has two data sources, one to RedShift and one to MySQL. How shall I code these in the script so that the published workbook have both of them?
Here is my code just for Redshift datasource:
` wb_item = TSC.WorkbookItem(name=reportname, project_id=tableau_folder)
if (server.workbooks.publish(wb_item, filepath, 'Overwrite',
connection_credentials=ConnectionCredentials(name=rds_username,
password=rds_password, embed=True))):
print(reportname)
print('Workbook has been published successfully.')`
Reacted by Kelvin
Activity
knguyen1794 commentedon Dec 8, 2019
I'm having the same issue. It seems like we can only embed 1 connection into the workbook/datasource. What if we have more than 1 source?
forzabarca88 commentedon Jan 23, 2020
One workaround is to publish without embedding, and then after publishing just update credentials on each connection via
knguyen1794 commentedon Jan 23, 2020
Yes. That's correct. I managed to achieve it with this way.
github-actions commentedon Aug 6, 2026
This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 14 days if no further activity occurs. If this is still relevant, please comment to keep it open.
github-actions commentedon Aug 21, 2026
Closing due to inactivity. If this is still relevant, please reopen or file a new issue.
jacalata commentedon Aug 21, 2026
For future readers: publish the workbook, then update each embedded connection with
workbooks.update_connection(). See the update_connection sample and the Connections docs.