Solved: Can't determine relationships between the fields

Anonymous · ‎07-30-2019

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 · ‎07-31-2019

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

View solution in original post

v-yuta-msft · ‎07-31-2019

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