KNOWLEDGE BASE

Error "data Sources That Contain Logical Tables Cannot Be Used As Secondary Data Sources For Data Blending"


Published: 03 Jun 2020
Last Modified Date: 12 Jun 2020

Issue

When blending data sources in Tableau Desktop, the following error might occur:

"Data sources that contain logical tables cannot be used as secondary data sources for data blending"

 

Environment

  • Tableau Desktop 2020.2.1 and later

Resolution

To resolve the issue, please follow the steps detailed below:
  1. Drag the first table to the relationship canvas.
  2. Double-click on the logical table in the canvas. This will open the physical layer.
  3. Drag additional tables to the join canvas to combine them using joins or unions.
The article The Tableau Data Model provides detailed information about Logical and Physical layers.

Cause

The data source tables used for data blending were combined in the logical layer (relationship canvas). For data blending, the tables need to be combined in the physical layer instead, where users can specify joins and unions.
 
Did this article resolve the issue?