How to Edit Connection in Tableau

Few things stop a Tableau project in its tracks faster than a broken data connection. Whether your database has moved to a new server, your password has been updated, or you're switching from a test environment to production, learning how to properly edit your data connection is an essential skill. This guide will walk you through exactly how to update your connections in Tableau Desktop and Tableau Server/Cloud without having to rebuild your visualizations from scratch.

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 Tableau Data Connection?

Before diving into the "how," it's helpful to understand the common scenarios where you'll need this skill. You're not just fixing something that's broken, you're often managing the natural evolution of your data infrastructure. You'll likely need to edit a connection when:

• Your database migrates to a new server. This is a classic example. The IT team moves the company's SQL database from an on-premise server to a cloud-based one like AWS or Azure. The data is the same, but the server address is completely different.
• Your login credentials change. For security reasons, your database password might have been updated, or you might be using a new dedicated service account to connect.
• You're moving from staging to production. Smart data teams test their dashboards against a development or staging database. Once everything is verified, you need to seamlessly switch the connection to point to the live production database.
• The database name or file path changes. Sometimes, instead of the server moving, the specific database you connect to is renamed. For file-based sources like Excel or CSVs, the shared network drive or folder location might have changed.
• You need to switch connection types. You might decide to convert a direct, live connection into a faster, more efficient Tableau Extract (.hyper file) to improve dashboard performance.

In all these cases, the goal is the same: point Tableau to the correct data source without losing all the formatting, calculated fields, and dashboard design you’ve already painstakingly created.

How to Edit a Connection in Tableau Desktop (The Easiest Method)

For workbooks you're building on your local machine, Tableau Desktop makes editing a connection straightforward. Follow these steps carefully.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Open your Workbook and go to the Data Source Pane

First, open the Tableau workbook (.twb or .twbx file) that has the connection you need to update. Once it's loaded, look at the bottom-left corner of the window. You'll see tabs for your dashboards and worksheets. Click on the Data Source tab to navigate to the data connection pane.

Step 2: Right-Click the Data Source and Select "Edit Connection"

In the Data Source pane, you'll see your connected data source(s) in the top-left area under the "Connections" header. Hover over your data source, right-click on it, and a context menu will appear. From this menu, select Edit Connection.

(Alternatively, you can click on a data source from the menu bar by selecting Data > Your Data Source Name > Edit Connection).

Step 3: Enter the New Connection Details

A dialog box will pop up, specific to the type of data source you are using (SQL Server, Google Sheets, Excel, etc.). This is where you'll enter the updated information. It might include:

• Server Name: The new server address or hostname.
• Database: The specific database or schema you need to connect to.
• Authentication: This could be your username and password, or you might need to select an option like "Integrated Authentication" for Windows credentials.
• File Path: For file-based sources, you'll see a browse button to navigate to the new location of your Excel or CSV file.

Carefully enter the new details. Typos in server names or incorrect passwords are the most common source of errors at this stage.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Sign In and Verify

After entering the new information, click the Sign In or OK button. Tableau will attempt to connect to the new source using the details you provided. If successful, your data preview will refresh with data from the new location. You can now navigate back to your worksheets and dashboards, which should all be functioning with the updated data source.

Editing Connections on Tableau Server or Tableau Cloud

Editing connections for workbooks that have already been published is a bit different. You have to consider whether it's a structural change or just a credentials update.

For Updating Credentials or Server Details

If you only need to update the server name or login credentials for a published data source, you can often do this directly on Tableau Server/Cloud without having to republish the workbook.

1. Log in to your Tableau Server or Tableau Cloud account.
2. Navigate to the data source you want to update (look under the Explore tab).
3. Select the data source. You should see tabs for "Connected Workbooks," "Data Quality Warnings," and so on. Click on the Connection tab.
4. You'll see the current connection details. Click the checkbox next to the connection and then click the Actions dropdown and select Edit Connection...
5. A dialog box will appear allowing you to change the Server Name, Port, Username, and Password. You can also specify here whether you want to prompt the user for their password or use a saved, embedded password.
6. Click Save. Tableau will test the connection, and all connected workbooks will now use these new details.

For Structural Changes (Changing Tables, Custom SQL, etc.)

You cannot make structural changes to a data source directly on Tableau Server/Cloud. For example, if you need to add a new table with a database join or modify a Custom SQL query, you must follow this workflow:

1. Open the workbook in Tableau Desktop.
2. Make the necessary changes in the Data Source pane.
3. Republish the workbook (and its embedded data source) or republish the data source separately to Tableau Server.

Trying to find a workaround for this will only cause issues. The correct process is always to edit in Desktop and then republish to Server/Cloud.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What About Replacing a Data Source Entirely?

Sometimes, editing a connection isn't enough. You might need to replace an old Excel file with a proper SQL database, even if the data structure is identical. In this case, use Tableau's "Replace Data Source" feature.

1. Add the new data source: First, connect to your new data source (the SQL database) by going to Data > New Data Source. Set it up just as you need it.
2. Go to a worksheet: Navigate to any sheet that uses the old data source (the Excel file).
3. Right-click the old source: In the "Data" pane on the left, right-click on the data source you want to replace.
4. Select "Replace Data Source...": A simple dialog box will appear. Use the "Replacement" dropdown to select your newly added data source.
5. Click OK: Tableau will automatically swap the old source for the new one. It will cleverly map fields from the old source to identically named fields in the new one. Calculated fields will be carried over, fixing themselves to point to the new fields.

A word of caution: This works best when the field names and data types in both sources are identical. If a field is named "Sales-Rep" in the Excel file and "SalesRep" in the database, Tableau won't map it automatically, and you'll have to fix broken fields manually.

Final Thoughts

Editing and managing your data connections is a routine part of working with Tableau. By understanding the difference between editing a connection directly and replacing a data source, you can handle almost any change to your underlying data without losing hours of work re-building your dashboards.

Frankly, this is the exact kind of manual configuration and troubleshooting that often keeps people from getting insights quickly. At Graphed, we've focused on eliminating that friction. You simply connect your marketing and sales platforms (like Google Analytics, Shopify, HubSpot) one time with a few clicks, and we manage the live data pipeline for you. It allows you to skip straight to asking questions in plain English and creating dashboards instantly, without worrying about server names or credential types. If you're interested in spending less time managing data and more time acting on it, you should give Graphed a try.