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?
This sounds like a defect. What version of Tableau Desktop and Serve is in use? In addition, please file a ticket with Tableau Support at https://support.tableau.com to investigate the details of this issue.