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

Problem creating a relationship bettwen tables

Hi Guys, hope you can help, im struggling to make a relationship bettwen two table, i put the images hope you can help me.

I have a Product Table

Sat25_0-1636377587958.png

The sales table

Sat25_1-1636377625208.png

and i want to make a relationship but gives me a error

Sat25_2-1636377711608.png

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @Sat25,

It seems like power bi tries to recognize the fields which you choose and it found fewer values can be matched, so it suggests your use 'many to many' mode with highlight notices messages.
For this scenario, I'd like to suggest you extract the two table values to create a bridge table with unique values to link two tables records.

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

HI @Sat25,

It seems like power bi tries to recognize the fields which you choose and it found fewer values can be matched, so it suggests your use 'many to many' mode with highlight notices messages.
For this scenario, I'd like to suggest you extract the two table values to create a bridge table with unique values to link two tables records.

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
HotChilli
Super User
Super User

It's a warning (not an error) so you can continue BUT I think 1->many from Product->Sales is what you want

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!