lookupValue

Cant get this to work at all: This is so over complicated, I am our only creator and am an analyst by trade (Excel, SQL, MySQL capable), and I have to make a decision on whether to use this software.

We need to get a column in table 1 to appear in table 2.

Both tables have been added via SMSS

table 1: Partner

            Column1: Name

            Column 2: Partnerreference

Table 2: Book

            Column 1: PartnerReference

I simply need the column "Name" to be added to the table "book"

This should be extremely simple but hey, it isn't. I have tried 15 different varients of Lookupvalue and nothing works. This took me 14seconds to do in excel, but I HAVE to do this within PowerBI within data that has already been loaded. Can anyone help, this is far too complicated and long winded for such a simple task.