Want to keep duplicates

[Pricey79]

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

[v-xiaotang · Accepted solution]

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.

[adamc-powerbi]

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]

@adamc-powerbi 

Thank you for taking the time to reply, but even with many to many I still get the same issue.  Thank you anyhow