Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

"Missing Relationship Between the Fields" why?

I have 3 tables in my Power BI model:

 

Table 1 - has a unique equipment ID for each record. I successfully joined Table 1 to Table 2 and Table 3 using the Equipment ID.

 

I can create a matrix using fields from Table 1 and Table 2 OR Table 1 and Table 3. BUT I get the error "There is a missing realtionship between these fields. Use autodetect..." when I try to include fields from Table 2 AND Table 3.

 

I don't understand why the model can't understand that there is an inherent relationship between tables 2 and 3.

 

Z

 

5 REPLIES 5
v-juanli-msft
Community Support
Community Support

Hi @Anonymous

For the relationship,Table2(many)-Table1(one)-Table3(many),

When you include fields from Table 2 AND Table 3 in the table or matrix visual, It can't detemine which value to match with the two tables, for they are have many values to each id in the table1.

You need to use aggregation to get data from Table 2 and Table 3.

9.png

 

Best Regards

Maggie

 

WolfBiber
Employee
Employee

Hi,

I don't know exactly your datamodel, but maybe this is the solution:

double click on the connections between the tables in Relationview and change "Cross filter direction" to Both

 

Greetings

Anonymous
Not applicable

Thanks. I do have "both" selected.  My model is real basic - not much more to it then these 3 simple tables with the Equipment ID fields as the join in the one-to-many relationships.

can you post a screenshot from you datamodel?

Anonymous
Not applicable

Here is the data model. Thanks:

 

Data_Model.JPG

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.