Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Paulyeo11
Impactful Individual
Impactful Individual

How to solve relationship many to many ?

Hi All

When i add SEGMENT table to my PBI file , when i try to link segment field , i get :-

Paulyeo11_1-1606517350266.png

 

The linkage have multiple relationship.

Paulyeo11_0-1606517243690.png

My PBI file :-

https://www.dropbox.com/s/ealmerjjo8bfbpw/PB_TDS_V077%20USE%20THIS%20FOR%20ASK%20Q%20add%20segment%2...

 

Paul Yeo

1 ACCEPTED SOLUTION
mohammedadnant
Impactful Individual
Impactful Individual

Hi @Paulyeo11 ,

 

Good day,

 

In order to avoid the manay-to-many relationship, you need to do the following steps

1. Extract unique values from 1 table - Treat this as a Master Table (Dimension table)

2. Add relationship with the table to fact table

3. Now you can use 1-Many relationship

 

Thanks & Regards,

Mohammed Adnan

www.youtube.com/taik18

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!

Thanks & Regards,
Mohammed Adnan
Learn Power BI: https://www.youtube.com/c/taik18

View solution in original post

3 REPLIES 3
mohammedadnant
Impactful Individual
Impactful Individual

Hi @Paulyeo11 ,

 

Good day,

 

In order to avoid the manay-to-many relationship, you need to do the following steps

1. Extract unique values from 1 table - Treat this as a Master Table (Dimension table)

2. Add relationship with the table to fact table

3. Now you can use 1-Many relationship

 

Thanks & Regards,

Mohammed Adnan

www.youtube.com/taik18

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!

Thanks & Regards,
Mohammed Adnan
Learn Power BI: https://www.youtube.com/c/taik18

Hi All

Thank you for sharing , but my issue is :-

Paulyeo11_0-1606538067634.png

 

edhans
Super User
Super User

You have to make it unique in one of the tables, and there can be no blanks or nulls in that field. Your segment_c field has a ton of blanks. You would have to:

  • Right-click on that field in Power Query and tell it to remove duplicates
  • Filter and on the dropdown menu, select "Remove Empty"

It can then be the 1 of a 1:Many relationship.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.