Getting data from another table in power query editor view

[melvinkishore]

Hi

I have a relationship between Table A and Table B and I am trying to retrieve some data from Table B into Table A in the power query editor review.

Can someone explain to me how to do this?

Thanks in advance.

[Seward12533 · Accepted solution]

In query editor merge the two tables with the first table as the primary and the second table as the secondary. Expand the embedded table 2 in the last column and select only th e. Maura you want to look up from the other table.

Tip if you don’t want to have the original tables in your data model. Right click the query names and uncheck the load option.