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: 08 Jul 2022

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"
or
"Internal Error - An unexpected error occurred and the operation could not be completed. Error Code: 0AEF6A81"

 

Environment

  • Tableau Desktop 2020.2.1 and later

Resolution

Option 1: Include all linking fields in the view, and aggregate secondary fields

Data blending will work when the secondary data source uses logical tables, as long as the following conditions are met:
  1. All active linking fields from the primary data source must be included in the view on a shelf other than the Filters shelf
  2. All fields from the secondary data source are aggregated, including dimensions
 

Option 2: Rebuild view with the data source using logical tables as the primary data source

The primary data source is set when the first field is dragged into the view. Once the primary data source is set, there is no way to change it; The view must be rebuilt from scratch
 

Option 3: Use joins instead of blending

Instead of blending multiple data sources, create one data source that joins all of the data using either physical or logical joins. If one or more of the data sources is a published data source, then the data cannot be joined in Tableau Desktop, but can be joined in Tableau Prep.
 

Option 4: Rebuild the data source using only physical joins 

  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

Data blending with a data source that uses logical joins has additional limitations as the data source with logical joins may contain tables that have a 1:many relationship or many:many relationship.
Did this article resolve the issue?