Forum Discussion
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.
Anonymous ,
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
v-yuta-msftCommunity Support
Anonymous ,
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.