Problem creating a relationship bettwen tables

[Sat25]

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

The sales table

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

[v-shex-msft · Accepted solution]

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

[HotChilli]

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