Forum Discussion
Helper VWant to keep duplicates
Hello everyone , I was hoping someone could help me please
I have a dashbaord with lots of different tables.
Two of these, Table 1 and Table 2 are joined by a relationship. It wont let me refresh as Table 2 contains duplicates, however I know it contains duplicates and want it to. Is there anyway around this please?
As an example:
Table 1 : Has Hooper, Brody, Quint and Hendricks
Table 2: Has an action for Hooper, then another action for Hooper, then one for Brody etc etc
Could anyone help please?
Thank you in advance
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.
3 Replies
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
- Pricey79
Thank you for taking the time to reply, but even with many to many I still get the same issue. Thank you anyhow
v-xiaotangCommunity Support
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.
