Help needed

[Kathir]

I have two sets of data and both have id columns. One set of id is distinct and the other is not. So theoretically if I link the two tables it should give me one is to many relationship in power bi. I tested both id columns in excel and the vlookup worked without any error. Upon linking the two columns, it shows many to many relationship. I have trimmed any white spaces and removed the blank rows. I couldn't figure out why power bi shows many to many  relationship? Help required pls 🙏 thanks 

[Anonymous · Accepted solution]

Hi @Kathir ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table.

2.Select the Manage relationships and create new relationships.

3.Select tables and date columns. The result is shown below.

4.One to many relationship that at least one of the id columns involved in the relationship had to contain unique values.

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

Hi @Kathir 

Bring the ID from the unique table in the table visual
Bring the same ID into the table and choose data show as COUNT
Right-click on the ID (which you bring 1st time and select "Show Item with no data"
Check if there is any count of more than one. If more than one, that means items are respected. Also blank value
Correct your data

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[PijushRoy]

Hi @Kathir 

Bring the ID from the unique table in the table visual
Bring the same ID into the table and choose data show as COUNT
Right-click on the ID (which you bring 1st time and select "Show Item with no data"
Check if there is any count of more than one. If more than one, that means items are respected. Also blank value
Correct your data

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[Wilson_]

Hi Kathir,

Can you please share a sample pbix file? (If you don't know how, please check the pinned thread in the forum.) It would make debugging your issue easier. 🙂