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.