topic Refresh error message demonstrably wrong - how to fix? in Developer

Refresh error message demonstrably wrong - how to fix?

duncfair — Mon, 15 Feb 2021 15:33:22 GMT

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 for columns that are used as the primary key of a table. Table: vw_TargetTool_Hist_2021.
Cluster URI: WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Activity ID: c49ccf6d-4deb-4fa7-a581-7f3ab15e9f36
Request ID: 4b196b8c-e85c-607a-1b59-779c3b9f419a
Time: 2021-02-15 14:08:00Z

Only 7 rows in this view (7 fiscal weeks) so far this year. There are no duplicates. The value '68' only occurs a single time, so it's not even a duplicate value within the column.

Re: Refresh error message demonstrably wrong - how to fix?

timg — Mon, 15 Feb 2021 16:24:38 GMT

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

Re: Refresh error message demonstrably wrong - how to fix?

duncfair — Mon, 15 Feb 2021 17:23:41 GMT

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.