Forum Discussion
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
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.