PowerBi Table won't work - visual cant display

[DynamicsHS]

Hi, 

I am trying to create a table in powerBi with dataverse data (dynamicsHR). I want to be able to create a table where I have the employers name and next to them their position title. However, In dataverse, the worker table does not have the workers position title. The position title is in the job position table and there is no link or relationships/column between the two tables. 

How would I go about creating this relationship so that I can create this simple table....

I have created a look up relationship in the powerapp environment - but that doesnt seem to work either. 

Everytime I drag the position name into the table next to the workers name - I get: 'cant display the visual'

Does anyone know what I would need to do? 

Kind Regards,

HS

[Anonymous]

Hi @DynamicsHS ,

You will need at least one generic column in both tables so that you could create a relationship between them. Otherwise you will need to create a bridge table manually then connect these tables through this bridge table.

Best Regards,

Jay