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.