Simple Table Join Fails?

[Ferdi24]

Hi, I could really need some help on this seemingly simple problem.

In the left box you can see my setup. On the right you can see that all users are assigned all items.
Why is this happening?

My Power-PivotTable uses [users]username and [items]name in the row field.

 

[mole999]

I'm not familiar with this process.

in SQL you would set

WHERE users.item_id = items.id which would provide the relationship

and SELECT
users.user_name, items_name

 

[Ferdi24]

Hi mole999,
I am familiar with how to solve this in SQL, but the objective is to do this using Power Pivot's data model.
THis is to allow colleagues to simply use Power Query to get the tables from a mySQL-Server and then have everything ready in Powerpivot to play around with the data. Without having to worry about SQL queries.