Forum Discussion
Duplicate Value error in incremental refresh
Hi Anonymous ,
It may be the "Auto-detect relationship" function that is turned on by default. You can check "Manage Relationships" to see if you have connected some tables without your knowledge, and automatically created several very strange relationships. When the only column is duplicated, the automatically created relationships now become "many-to-many. You can disable these unnecessarily created relationships, and turn off the "automatically detect relationships" function.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Did changes as you said. But Still im getting the same error. Switched Off incremntal refresh for the table which is throwing that error then it got resolved. But i need to turn on the Incremental refresh for future data.
Will be appreciated if any one provides solution