cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dali748 Regular Visitor
Regular Visitor

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

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?

 

wo_id-error.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
AnkitBI Established Member
Established Member

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

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 Regular Visitor
Regular Visitor

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

@AnkitBI Thank you for the reply! 

 

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

 

Thank you!

AnkitBI Established Member
Established Member

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

Using Relationship Tab.
Community Support Team
Community Support Team

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

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Community Support Team
Community Support Team

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

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,051)