Forum Discussion

soptim_vond's avatar
soptim_vond
Frequent Visitor
5 years ago

Incremental Refresh Error: Duplicates in primary key (even after remove duplicates)

Hi folks,   I´m having the following problem with incremental refresh:    My model includes a table in which I create a unique key by concatinating a date column with an id column (which results ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Your issue is probably unrelated to incremental refresh.  Run a fixed query (with hard coded values instead of  RangeStart and RangeEnd) and you will likely see the same issue.  It can also be related to null values in your index column

soptim_vond's avatar
soptim_vond
Frequent Visitor
5 years ago

Thanks for your suggestion, however that is exactly what I have done in order to rule out other causes. Refreshing the data for the same timespan without incremental refresh is completed successfully. Any other ideas?