Forum Discussion
Want to keep duplicates
Hi Pricey79
Thanks for reaching out to us.
please refer to this solved post with same issue: Solved: Refresh error: "...contains duplicate value...and ... - Microsoft Power BI Community
refresh error --> ".....contains a duplicate value....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."
solution1: "Hey, i managed to fix the issue in Relationships by changing the Cardinality to 'Many to One'. " --donesb1987
solution2: "Another way I used to solve the error was to uncheck the "Autodetect new relationships when data is loaded." " --wonyango
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I think you want to consider re-designing your model using star schema principles. However, I'll answer your question as you asked it.
You need to change the relationship on Table 2 so that it isn't the "one" side of a "one-to-many" relationship. The easy fix, but could cause you problems later down the line, is to change it to many-to-many.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Thank you for taking the time to reply, but even with many to many I still get the same issue. Thank you anyhow
