Duplicate value 0 and this is not allowed on the one side of a many-to-one relationship error?

[Dali748]

Please see error I'm receiving below, for some reason I keep on receiving this error when I try to refresh my data.  I talked to our DB SQL administrator and he says that the table doesn't have this restriction and believes it's a PowerBI issue.

Does anyone know what can be causing this issue and how to fix it?

[AnkitBI]

Relationship column on one side of relationship cannot have duplicate values. Either remove duplicates from Column or create Many to Many relationships.

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

[Dali748]

@AnkitBI Thank you for the reply! 

How do I change it to many-to-many relationship?

Thank you!

[v-piga-msft]

Hi @Dali748 ,

Have you solved the problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Dali748 ,

Please refer to the document below about creating many to many relationship in power bi.

https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships

Best  Regards,

Cherry

[AnkitBI]

Using Relationship Tab.