Cant see fields from a joined table

[83dons]

I have joined my custom table MASTER to an existing table that has been imported. However I am not sure how to import any of the columns from the exsiting table to my MASTER table as they arent showing up. If I manually type in the field or table name it adds a column but has error all the way down. It must be possible to add this in I would think once the relationshio is established in the model? I think the table should appear as a new column with that table name that is expandable where I can choose the fields I want. Not sure if I need ro refresh someonething though for that column to appear. I tried custom column but it just has error in every row.

model setupcreating a custom columnerrors in custom column

[bcdobbs · Accepted solution]

Hi,

You're mixing two different sections.

Your model with the relationships exists once data is loaded. Whereas the screen shots of the tables are from the Power Query section of Power BI which is used for data transformation.

Relationships in the model aren't visible to Power Query.

Options

1) In Power Query use the "Merge" option to pull in related data.

2) In Power Bi once the model is established you can add a calculated column and use DAX: NewColumn = RELATED (TableName[ColumnName])