question

KaitlinLewis-4806 avatar image
0 Votes"
KaitlinLewis-4806 asked DSPatrick commented

Power BI: Duplicate Value Issue

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-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image
1 Vote"
DSPatrick answered

Power Bi is not currently supported here on QnA. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/

--please don't forget to upvote and Accept as answer if the reply is helpful--


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KaitlinLewis-4806 avatar image
0 Votes"
KaitlinLewis-4806 answered DSPatrick commented

Thank you for the redirect, much appreciated!

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

You're welcome.



0 Votes 0 ·