cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
system243trd Frequent Visitor
Frequent Visitor

Can't determine relationships between the fields

I have a three tables in a Power BI report.  They are all linked via the same concatenated ID field but the relationship type consits of a one to many from C to A and C to CA.  I have tried to add three fields to a report e.g. c.Work Batch, a.Item and CA.customer.  I receive the following error message when I try to create the report 'Can't determine relationships between the fields'.  Please can anyone advise.

image1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Can't determine relationships between the fields

@system243trd ,

 

Which column has been added to which table, could you clarify more details about your operation? In addtion, I guess the issue you occurred should be related to the blog below, you may also refer to the blog for solution.

https://prologika.com/determining-power-bi-relationships/

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Highlighted
LW Member
Member

Re: Can't determine relationships between the fields

PBIX please!
Thanks
Community Support Team
Community Support Team

Re: Can't determine relationships between the fields

@system243trd ,

 

Which column has been added to which table, could you clarify more details about your operation? In addtion, I guess the issue you occurred should be related to the blog below, you may also refer to the blog for solution.

https://prologika.com/determining-power-bi-relationships/

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 376 members 4,400 guests
Please welcome our newest community members: