Underlying Data from Secondary Data Source Not Displayed or Consistent with Blended Data
Published: 25 Apr 2013
Last Modified Date: 07 Sep 2017
IssueAfter 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.
- Tableau Desktop
- Blended data
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.
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.
CauseThis 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.