1 Reply Latest reply on Aug 10, 2017 2:15 PM by Patrick A Van Der Hyde

    Published Data Source Differs from SQL Viz

    Greg de Lima

      Our Tableau Server & Tableau Online refreshes periodically from a SQL viz, constructed from underlying tables.

      The issue, however, is that when we publish an extract of the SQL viz to Tableau Server (our company will not allow us to open up a direct port to the SQL Server), the joins being leveraged get skewed.

       

      Expected Result:                                             Actual Result:

      We have attempted flattening the whole file to a new table.

      Why does the extract & publishing process cause a one-to-one match lead to a one-to-many result, despite the viz being a left join?