Power BI can't determine the relationship between two or more fields'.

[Anonymous]

I've imported three tables into Power BI, have added relationships between them, and am now trying to add fields from the various tables to a table on the canvas.

The table names are named Employees, Job History, and Salary History.

Employees is joined to Job History using EmployeeID as a 1:Many relationship, and also to Salary History using EmployeeID on a 1:Many relationship.

I can add fields from the Employee table and EITHER the Salary History OR the Job History table to the table on the report canvas. However, if I try to add fields from all three tables, I'm seeing the error 'Can't display the data because Power BI can't determine the relationship between two or more fields'.

Could anyone advise where I'm going wrong? Many thanks.

[lbendlin]

You have one dimension (Employees) and two facts ( Jobs and Salaries).  If you add a field from the dimension first (like employee name) then you can add fields from both facts.  But if you add a field from Jobs first, and then try to add fields from Salaries then you will get your error as there is no relationship between the two facts (and there shouldn't be one).

Always use the dimension field as the first field.