Please check if you date column has consistent format (m/d/yyyy or yyyy-mm-dd) and check if its consistent data type,
even a single row with var_char can throw error.
Best way is to use integer dates.
I tried with a sample data of 2 rows with another 2 rows getting appended. So there wasnt any nulls or strings for Date field.
I have tried with incremental column with ID (int) column also, but in vain.
It always overrides the old data and doesnt append. Any example of actual working incremental refresh for tableau wdc would be helpful
incremental refresh should append the new rows, although it can't affect the existing rows.
do you have multiple columns set for incremental filter? if using multi-columns will work too.
No, not using multi columns,
Only using single column -> incrementColumnId: "Request_Id"
have you successfully used it before and not just this time? if yes then it might be a product bugor try using the same sub-version of tableau desktop and server... example: 10.3.1 desktop may have issue with 10.3.0 server ???
if you are attempting it for the first time? then follow the standard protocol mentioned here: Refresh Extracts
I have not achieved this previously at all.
Extract Refresh for other data sources are working fine. Like I am able to refresh extracts from SQL server, netezza etc. I am only having problems refreshing the extracts through WDC alone.
Also I am using the same version of desktop and server 10.2.1 and I dont have permission to upgrade to a different version since it is used enterprise wide.
please try full refresh. it should work.
personally I hate incremental refresh because they do not deliver the necessary functionality.