1 of 1 people found this helpful
I'd start by looking at the Tableau logs of the extract being created. That will show you the query used to retrieve the data from Postgres and tell you how many rows it returned.
That should at least let you see whether the query got all the correct rows and then Tableau lost some in the process of writing the extract or whether the query was wrong for some reason. There might even be some other useful messages.
It takes a bit of poring over some fairly verbose logs, but you often find clues that may.
Sorry for the slow response. I was on leave. I cleared my logs to try this and like magic, 7th time lucky, it actually worked! This is a bit frustrating actually because I now don't know why it extracted less records to start with....
Thanks for your help anyhow.