Copy Query Table Column data from one Table to another

[bdehning]

I added a new Query Table into Power BI but I need to insert a new column into that table from another query table. 

How do I accomplish that? 

[Arul]

@bdehning ,

Do you have any common column between these two tables?

Thanks,

[bdehning]

Actually I do have one.  Number of rows are different and why I want to move data from one to the other and thenremove the outdated Query

[Arul]

@bdehning ,

Could you provide the clear explanation and the expected output?

Thanks,

[bdehning]

Well I was using a desktop table with two columns and I would occasionaly add rows to the table when made aware of additions by another department.   

I found the main column is kept on a server and is updated, but I would need to add the data for the second column rows which could be added on desktop.      

I want to connect to Server Table column with desktop Power BI and have the the other column that I could fil out and update when new server rows are added.