Forum Discussion
Solved
Refresh error message demonstrably wrong - how to fix?
Data source error: Column '0-30%' in Table 'vw_TargetTool_Hist_2021' contains a duplicate value '<pii>68</pii>' and this is not allowed for columns on the one side of a many-to-one relationship or fo...
Hi duncfair,
Could you check if the relationship cardinality between this table and other tables is set correctly? If these are not set correctly it could also cause a duplicate error, so perhaps that's the culprit.
Regards,
Tim
Hi duncfair,
Could you check if the relationship cardinality between this table and other tables is set correctly? If these are not set correctly it could also cause a duplicate error, so perhaps that's the culprit.
Regards,
Tim
Hi Tim,
Thanks! I was not the original creator of this report (I'm the backend data guy) and the issue was an auto-created relationship that didn't make any sense. Changing that resolved the error.