PowerBI Data Modelling Report Error

I think the issue here is that your middle table ie the master, that table should have the many relationship side in it not the one.  your lookup tables have the many and your 'join table' has the one.

so effectively in order to combine all those table together effectively into one visual,  you need to have your master as the many side and your lookup tables as the one side of the relatioships.

you can see that the joins work just fine as long as you dont select more than 2 tables.  Ie the file you sent me over, if you remove one field from the visual you see it works fine and that is true for all the tables.

this is a modelling issue in order to correct this you will need to model your data correct by having the lookup on the one side (contacts, account etc) and the master on the many side.