Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
danextian
Super User
Super User

Bi-directional relationship not working as expected

‎09-03-2017 08:54 PM

Hi All,

 

I'm trying to figure out and fix relationships betweent data tables. I have Quote Actuals table that is linked to Quote Header by Quote Number field. The Quote Header is linked to Quote Numbers, again, by Quote Number field.  And the Sold-to is linked to SAP Record by Sold-to field. The relationships travels fine betwen Quote Actuals and Quote Header but not when it tries to travel to Quote Partners from Quote Actuals.  All relationships are bi-directional. Please see screenshots below.relationship error.png

 

relationship.png

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Labels:
Message 1 of 2
637 Views
0
1 REPLY 1
v-yulgu-msft
Microsoft Employee
Microsoft Employee

‎09-05-2017 12:26 AM

Hi @danextian,

 

Since there is a one to many relationship between Quote Actuals table and Quote Header, also, the Quote Header is linked to Quote Partners with a one to many relationship. So, there existing an indirect many to many relationship between Quote Actuals and Quote Partners. That is why it failed to travel to Quote Partners from Quote Actuals, as a record row cannot determine the mapping rows in another table. You could not add both Quote Number columns from Quote Partners and Quote Actuals into a single table visual.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 2
613 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All