3 Replies Latest reply on Jan 23, 2015 1:10 PM by Alexander Mou Branched to a new discussion.

    FAQ:  Replace Data Source

    kettan

      The abundance of ideas about replacing data sources tells me that this is a pain felt by many.

       

      Recommended

      Select each worksheet in the workbook before replacing the data source and see if it helps.

       

      Answers

      2013-07-12    Re: Change data source without destroying the formatting   by  Jonathan Drummey

       

      Resources

      Knowledge Base:  Replacing a Data Source | Tableau Software

      TabWiki:  Retaining Quick Filter Options when Replacing Data Sources

       

      Blogs

      2015-07-05    Vizible Difference: Replacing Data Source the Fast Way

      2015-01-23    Vizible Difference: Replacing Data Source Breaks Everything: Cause, Workaround & Ultimate Fix

      2014-06-09    The Information Lab: Using Tableau’s Replace Data Source function

      2012-12-17    Tableau Friction: Changing the Database Server Name in multiple Workbooks

       

      News

      2015-04-23    Tableau is "working on several improvements to data sources in the next year"

       

      Questions

      2016-02-18    Why my colors and filter formatting are changing in tableau after reaplcing data source

      2015-11-05    Can't I rename published data source?

      2015-11-03    When I replace a reference, most fields with ! disappear

      2015-10-07    Changing data connection from Dev to QA in Tableau

      2015-07-05    Replacing Data Source the Fast Way

      2015-05-18    How come my calculated fields get removed when I upload a new file w/more rows?

      2015-04-10    My calculation fields rename themselves

      2015-01-23    Default format after data replacement

      2015-01-22    Is it possible to switch databases from mysql to oracle without rebuilding sheets?

      2015-01-21    Re: How can I get my labels to be positioned starting after the horizontal bar chart ends

      2015-01-19    When changing a data source in a Tableau Dashboard lose all previous formatting…

      2015-01-12    Problem with replacing data source

      2014-12-19    Can we dynamically change the datasource

      2014-12-10    Possible to change target db - trying to develop on dev db and then change to prod db

      2014-11-28    Replace data source in one dashboard not all

      2014-11-26    Replacing data source...

      2014-11-13    Replacing the data source not possible with calculated fields and filters

      2014-11-07    How can i replace excel datasource with access data source where the access datasource…

      2014-11-06    Replace Data Source....

      2014-10-28    Is there a way to dynamically modify the data source of a packaged workbook?

      2014-10-13    Do we have to redo all the work if the databases are changed

      2014-10-13    Data source questions

      2014-10-10    When replace data source I losted charts

      2014-10-08    How do I share a dashboard where an end user can replace / augment the data source?

      2014-10-06    Company changed data source, need to edit data import

      2014-09-29    Replace data source and nothing happens

      2014-07-10    replace data source, keep color scheme?

      2014-06-19    Dimension field lost and calculated field invalid after replace data source

      2014-05-20    Replace Data Source - from one Tableau Server site to another

      2014-05-14    How to keep hierarchies and folders when replacing datasource

      2014-04-29    Issues when replacing a data source

      2014-04-29    Replacing Data Source destroys filter settings

      2014-04-20    replacing datasource with new connection and retaining old data source

      2014-04-11    How to Replace Data Source while retaining parameters and calculated fields

      2014-04-09    How can I replace an SSAS data source defined multiple times in a workbook?

      2014-03-19    Replace data source

      2014-03-07    Tableau replace data source greyed out, How to resolve it?

      2014-03-04    Replacing Data Source Duplicates Color Legend, Bug?

      2014-02-20    Inconsistent use of column name aliases when replacing a data source

      2013-10-30    Colour Palette not being used when underlying data changes

      2013-10-29    Error replacing a local data source to published to server one

      2013-08-15    Replace data source on a single worksheet

      2013-08-07    Calculated fields become invalid on replacing data source

      2013-07-08    Change data source without destroying the formatting

      2013-04-11    Replacing Data Source - "Reference to undefined field" in calculated field

      2013-01-13    "Replace Data Source" faded

      2012-12-01    The specified item was not found.

      2012-09-27    Replacing Data Source: fields gone missing

      2012-05-25    Replacing a data source by editing the workbook .xml

      2012-04-10    Extract field corrupted

      and more  http://community.tableau.com/search?q=replace+data+source

       

      Ideas

      2016-09-08   Replacing a data source and mapping to new fields

      2015-12-03   Replace data source once at a time

      2015-12-03    Keep changes to data when data source is replaced

      2015-11-30    Stop Changing Filters & Colors When Replacing Data Source

      2015-07-02    Replacing Data Source with option to copy over calc fields, groups, sets etc.

      2015-05-12    Maintain Color Palette and Legend Colors when Replacing Data Source

      2014-12-10    Replace Data Source does not replace reference in other data source's calculated field

      2014-12-05    Swapping Data Sources

      2014-07-31    Replace References Across Data Sources

      2014-04-24    Ability to switch primary and secondary data sources

      2014-04-09    Allow replace data source to function in step with customized views

      2014-03-14    Customized views should continue to work after replace data source

      2014-03-24    To retain customised formatting of report text and colour legend on replacing data source

      2014-03-24    Functionality in a future release of Tableau Desktop to create aliases in a workbook
                                     that uses a published data source

      2014-12-16    Bring back the 'Data Source Name Conflict' Message for Bookmarks and Copied/Pasted Sheet

      2013-12-09    Data Source Migration Tool

      2013-04-08    Drag and drop replacement of data sources

      2013-03-13    Transfer Aliases and Color Settings with Replace Data Source

      2012-12-14    Save workbook using server extract as packaged workbook

      2012-03-02    Change datasource on one worksheet and not others

       

      Other FAQ collections:   FAQ Hub