KNOWLEDGE BASE

Underlying Data from Secondary Data Source Not Displayed or Consistent with Blended Data


Published: 25 Apr 2013
Last Modified Date: 07 Sep 2017

Issue

After selecting the view underlying data icon, only rows from the primary data source are displayed. 

Additionally, when viewing the underlying data of a workbook using blended data, the underlying data might be inconsistent with the blended data.

Environment

  • Tableau Desktop
  • Blended data

Resolution

Option 1

Create a new Worksheet and build a Crosstab view that shows the underling data, then use a Dashboard and Dashboard action to navigate the view. For more information, see Dashboards and Actions

Option 2

Use of the Cross Database Join functionality introduces in Tableau Desktop 10.0. More information about this feature can be found in this Quick Start guide: Combine Tables Using Cross-Database Joins.

Cause

This behavior is expected when using a blended view. The feature "View Full Data" sends a query to only the primary data source on a given worksheet that occurs separate from the blending operation.

Therefore, the ability to see data from a secondary data source via "View Data" is not built into the product. 
Did this article resolve the issue?