Forum Discussion

转角遇见你's avatar
转角遇见你
Frequent Visitor
1 year ago

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

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.