Question: how to copy data from one table to another in power bi?
Answer: In the data tab.
Right click anywhere on the table (data)
You'll see two options Copy and Copy Table. Copy Option – This will copy the only the column selected (in yellow and grey) ... 
You can then simply paste the data into excel.