Full extract or incremental extract?
Have you tried refreshing the viz (F5) to check if that's the caching on Tableau side and actual extract was indeed refreshed?
Are you incrementally refreshing the extract? If so, no previous rows will be updated--it's a new records / append-only operation. If you're fully refreshing the data, I'd double check your extract filters, your datasource filters, and possibly any filters you have on your worksheet.
Thanks for the reply.
This is a full refresh, not incremental. Additionally there are no data source filters.
To clarify this point - Tableau is displaying information that outright no longer exists in the underlying SQL table. In other words, there are no more records that say "NO", they have all been updated to "YES". In this way, filters shouldn't be the source of the issue, as no records at all say "NO" regardless of filtering.
What database is this against?
Also, when you go to that Data Source tab and load up first 1000 rows - do you see YESes or NOs?
I've recreated a simplified version of my workbook to demonstrate this issue. Please use the following steps and see the attached SQL and Workbook
/*RUN THE FOLLOWING IN ORDER*/
--1) CREATE CUSTOMERS TABLE
CREATE TABLE customers
--2) POPULATE CUSTOMERS TABLE
INSERT INTO dbo.customers
VALUES ( 'Dmitry', '1'), ('Chris', '2')
--3) CREATE LOOKUP TABLE
CREATE TABLE PaymentLookup
( PaidID VARCHAR(MAX),
--4) POPULATE LOOKUP TABLE
INSERT INTO dbo.PaymentLookup
VALUES ( '1', 'NO'), ('2', 'YES')
--5) CREATE TABLEAU WORKBOOK
--CONNECT TO CUSTOMERS VIA CUSTOM SQL - "SELECT * FROM CUSTOMERS"
--CONNECT TO LOOKUP VIA DRAGGIN TABLE INTO DATA SOURCE
--JOIN THE TWO TABLES ON PAYMENTID (OCCURS AUTOMATICALLY)
--6) CHANGE UNDERLYING DATA IN SQL
UPDATE dbo.customers SET PaidID = 2
--7) REFRESH TABLEAU EXTRACT
--FIELDS REMAIN NOT UPDATED
I got to ask - are you sure you are refreshing extract and not datasource?
See Matt's 2nd image - there's Refresh under Extract sub-menu (NOT the 2nd Refresh on the dropdown menu).