Can't determine relationships between the fields

[system243trd]

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.

[v-yuta-msft · Accepted solution]

@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.

[Anonymous]

PBIX please!
Thanks