Forum Discussion
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 to make a relationship but gives me a error
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
2 Replies
It's a warning (not an error) so you can continue BUT I think 1->many from Product->Sales is what you want
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
