undefined

[转角遇见你]

Duplicate values have been added to the primary key of the data source in power bi, causing failure to refresh. Is there any way to import the data source with duplicate primary key values

[Anonymous]

Your solution is great lbendlin 

Hi, @转角遇见你 

Based on your description, I've created the following two example tables:

The relationship is as follows:

When I add a duplicate value to side 1, I refresh the data:

As Super user says, you can disable 1-to-many relationships or change relationships to many-to-many:

If you don't know about these relationships, you can follow the links below to learn about it:

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Only if you deactivate the 1:* relationship.