Power Pivot: 2 small linked tables returning too many results

[tenone60]

I have 2 linked tables and wish to create a pivot table showing employee ID, Name and the person's related Role. The tables are linked on Employee ID but query displays what's shown below:
Emp ID Name
123 John
456 Bill
789 Joe


Empl ID Role
123 Admin
456 CEO
789 VP

Query Rows
123 John Admin
123 John CEO (incorrect)
123 John VP (incorrect)
456 Bill Admin (incorrect)
456 Bill CEO
etc.

I would insert screen shots but not sure how to do that. Any help would be greatly appreciated. Thank you

 

[alfranco17]

Adding a measure helps to get rid of incorrect values.

Perhaps Get and transform (power query) could do the join you need more efficiently.

 

[tenone60]

Awesome! Adding a measure did get rid of the incorrect values. Many thanks