KNOWLEDGE BASE

Displaying Duplicate Summary Data or Multiple Unexpected Table Calculation Results When Connecting to PostgreSQL


Published: 01 Feb 2017
Last Modified Date: 10 Feb 2017

Issue

When connecting live to a PostgreSQL data source, then some dimension members may appear twice in the summary data tab of the view data dialog.
  • Adding a table calculation, such as INDEX(), to the view will return two values for a single dimension member.
  • Adding additional fields to the view or disaggregating measures may change which dimension members are affected.

Environment

  • Tableau Desktop
  • PostgreSQL

Resolution

Option 1

Reinstall Tableau Desktop in order to install the correct version of the PostgreSQL driver.

Option 2

Download the PostgreSQL driver and install it.

Cause

Not all versions of the PostgreSQL driver are compatible with Tableau Desktop. 
Did this article resolve the issue?