How to Edit a Published Data Source in Tableau

You've meticulously crafted and shared a central data source in Tableau for everyone on your team to use - a single source of truth. But then, a new requirement comes in. A column name needs to be changed, a calculation needs to be updated, or a new field has to be added from the database. Now you're wondering how to edit that published data source without breaking all the dashboards connected to it. This guide will walk you through the correct, safe process for updating your shared data sources and a few best practices to follow along the way.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Published Data Source Anyway?

Before jumping into the "how," let's quickly clarify what we're dealing with. In Tableau, you can work with data in two main ways:

• Local Data Source: This is a data connection that's specific to a single Tableau workbook. It's saved within your .twb or .twbx file. It’s quick and easy for individual analysis, but if you have five different workbooks analyzing the same sales data, you’ll have five separate, independent local data sources.
• Published Data Source: This is a centralized, standalone data connection you publish to Tableau Server or Tableau Cloud. Instead of being tied to one workbook, any workbook (with the right permissions) can connect to it.

Using published data sources is a best practice for teams because it ensures everyone works from the same data definitions, calculations, and logic. A calculated field for "Profit Margin," for example, is defined once and is consistent everywhere. This consistency is precisely why editing one requires a more deliberate process than just tinkering with a local connection.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Would You Need to Edit a Published Data Source?

Your data and business needs are never static. Here are a few common reasons you'll find yourself needing to update a published data source:

• Adding new columns: Your database developer just added a new Customer_Segment field to the underlying table, and you need to include it in your analysis.
• Creating or updating calculations: You want to add a new calculated field like Cost_Per_Acquisition that can be used across multiple dashboards. Or, you need to adjust the formula for an existing Regional_Sales_Target calculation.
• Changing data types: A field like OrderID is coming in as a number when it should be treated as a string dimension.
• Modifying joins or relationships: You need to add another table to your data model or change how existing tables are related.
• Updating connection info: Your database was migrated to a new server, and you need to point the data source to the new address or update the credentials.
• Changing extract filters: You want to adjust an extract filter to include the last 3 years of data instead of the last 2.

Step-by-Step Guide: How to Edit a Published Data Source Safely

The core process involves making a local copy of the data source, editing it in Tableau Desktop, and then republishing it to overwrite the existing version on the server. Follow these steps to ensure a smooth update.

Step 1: Create a Local Copy

First, you need to bring the data source from your Tableau Server or Cloud environment down to your local machine. You can't edit it directly in the web browser.

1. Log into your Tableau Server or Tableau Cloud account.
2. Navigate to the project or folder where your published data source is located. It will have a cylinder icon next to its name.
3. Click the three dots (...) next to the data source name to open the actions menu.
4. Select Download. This will save a local copy of the data source file to your computer. It will have either a .tds (Tableau Data Source) or .tdsx (Tableau Packaged Data Source) extension. A .tds file contains the connection information and metadata (like calculated fields and formatting), while a .tdsx file also includes an extract of the data itself.

Alternatively, from within Tableau Desktop, you can connect to your server, right-click the published data source, and choose "Create Local Copy."

Step 2: Open and Edit the Local Copy in Tableau Desktop

Now that you have the file, it's time to open it in Tableau Desktop and make your changes.

1. If it didn't open automatically, find the downloaded .tds or .tdsx file and double-click it.
2. This will open a new, blank workbook in Tableau Desktop with your data source already loaded in the Data pane. You're now working with the local copy, so any changes you make here won’t affect the live published version until you republish.
3. Make whatever changes you need. This could be:

Take your time during this step to ensure all modifications are correct. You're updating the single source of truth, so accuracy matters.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Republish and Overwrite the Old Version

Once you are confident in your changes, the final step is to publish this edited local version back to the server, overwriting the original one.

1. In the Data pane, right-click on the name of your data source.
2. Select Publish to Server…
3. The publishing dialog box will appear. Here's the most critical part: you must publish it to the same Project with the exact same name.
4. When you do this, Tableau will recognize that a data source with this name already exists and will pop up a warning: "A data source named '[Your Data Source Name]' already exists in this location. Do you want to overwrite it?"
5. Click Yes to confirm.
6. Adjust any other settings as needed, like permissions or the extract refresh schedule, and then click Publish.

That's it! Your published data source has now been updated. Any new workbook connecting to it will see your changes immediately. Workbooks that are already open may need to have their data connection refreshed (Data Menu > [Your Data Source] > Refresh) to pull in the latest changes.

For Connection Info Only: The "Edit Connection" Shortcut

What if you just need to update the database password or server address? For this simple task, you don't need to go through the whole download-and-republish workflow.

Tableau provides a shortcut for editing just the connection details. Note that this only works for connection information - you can't add calculated fields or change data types this way.

1. On Tableau Server/Cloud, navigate to your data source.
2. Click on the Connections tab.
3. You will see a list of active connections used. Check the box next to the connection you want to update on the list and at the top right of the section, click the Actions menu and select Edit Connection.
4. A dialog will pop up, allowing you to change the server address, port, database name, and username/password credentials.
5. Update the details and click Save.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Best Practices and Common Pitfalls to Avoid

Editing a resource shared by many people requires a little extra care. Keep these tips in mind to prevent headaches down the road.

• Communicate with Your Team: Before making a significant change - especially removing or renaming a field - let your fellow Tableau users know. If you rename a field used in ten different dashboards, that field will break in all ten of them. A quick Slack message can save everyone a lot of time.
• Test Before Publishing Overwrite: Before you click Publish to overwrite, it is a good recommended approach to consider publishing your updated data source with a slightly different new name first, such as '[Data Source Name] - Test.' Connect it to a copy of your main dashboard to ensure everything works perfectly. Once you've confirmed it's safe, you can then move forward and republish to overwrite the live version.
• Check Downstream Workbooks: After you overwrite the data source, open a few of the most critical workbooks that connect to it. Make sure they load correctly and that no fields have a red exclamation mark next to them, which signals an error.
• Confirm Your Permissions: To overwrite a published data source, you need to have the appropriate permissions on Tableau Server/Cloud. Without publisher or editor permissions on that specific data source, you won't be able to complete the final step.

Final Thoughts

Managing and editing published data sources is a necessary part of maintaining a healthy Tableau environment. By following the download, edit, and republish process, you can safely update your central data connections while maintaining consistency and trust across all your dashboards.

As powerful as centralized data sources are, notice that the entire process still relies on manual downloads, configuration checks, and redeployments. For a lot of teams, especially in marketing and sales where speed matters, this kind of upkeep can become a bottleneck. At Graphed , we help you skip these technical hurdles entirely. We let you connect your marketing and sales platforms (like Google Analytics, Shopify, and Salesforce) once and then just ask an AI analyst for the charts and dashboards you need. Everything stays automatically updated with real-time data, so you get the answers you want in seconds instead of spending your afternoon managing data sources.