Forum Discussion
Solved
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 The sales table and i want t...
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
Community Champion
Community ChampionIt's a warning (not an error) so you can continue BUT I think 1->many from Product->Sales is what you want