KNOWLEDGE BASE

Connecting to Multiple Data Sources Without Joining or Blending


Published: 30 Aug 2016
Last Modified Date: 06 Dec 2016

Question

How to have multiple data sources in the same workbook, but not join or blend their data.

Environment

Tableau Desktop

Answer

  1. Connect to the primary data source as usual. See connecting to data.
  2. To connect a second data source, navigate to "Data" in the toolbar, and select "New Data Source." (This can also be done with Ctrl+D)
  3. This can be done as many times as necessary to add the desired data sources.
  4. When creating worksheets once all data sources are connected, it is important to use one data source per worksheet to prevent blending. Otherwise Tableau will automatically look for a linking field, or it will not be able to populate secondary data source information if there are no linking fields.
Did this article resolve the issue?