KNOWLEDGE BASE

Colors Change After Replacing Data Source


Published: 21 Mar 2014
Last Modified Date: 06 Sep 2017

Issue

After replacing a data source, colors that were previously defined revert to the automatic color palette.

Environment

Tableau Desktop 9.2 and earlier versions

Resolution

Option 1: 
Upgrade to Tableau Desktop 9.3 or a newer version. For more information, see Upgrading Tableau Desktop

Option 2: 

Let all the sheets in the workbook load completely before replacing the data sources:
  1. Open the workbook in Tableau Desktop.
  2. Open each sheet and wait for the sheet to load.
  3. After all sheets have loaded, replace data sources. For more information, see Replacing a Data Source.


Option 3: 

Instead of removing and adding a table to the data connection in the Data Source tab, drag and drop the new table on top of the old table to be replaced.

Cause

Many issues with unexpected formatting behaviors when replacing data sources were corrected in Tableau Desktop 9.3.
Did this article resolve the issue?