Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
It's a warning (not an error) so you can continue BUT I think 1->many from Product->Sales is what you want
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |