How to merge two tables selecting only columns that you needed

[Anonymous]

Hi Team,

Good Day !

Is there any way to merge table into new table selecting only all the needed column from the two table. I did the left outer join but I can only select the column on the joining table not on the main table. I'm new on powerbi can you please help thanks 

Best Regards 

John 

[johnt75 · Accepted solution]

On the home tab in Power Query there is a "Choose columns" button, that gives you a quick way to select just the columns you need.