Power BI: Duplicate Value Issue

Kaitlin Lewis 21 Reputation points
2021-06-24T14:20:00.67+00:00

Hi All,

I've been getting 1 of 2 error messages when I try to refresh:

1) Data source error: Column 'PartNum' in Table 'job head part cost' contains a duplicate value '<pii>00125-002</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: job head part cost.

2) Data source error: Column 'PartNum' in Table 'Erp PartCost' contains a duplicate value '<pii>00125-002</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: Erp PartCost.

However, when I look into both of those tables, neither actually has a part number 00125-002. Rather, each has a part number 00125-000 (but no 00125-002).

What should I do to fix/troubleshoot this? Thanks!!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,923 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. Kaitlin Lewis 21 Reputation points
    2021-06-24T16:09:07.057+00:00

    Thank you for the redirect, much appreciated!