Forum Discussion
Copy Data From One Query, Append to Another
I know how appending tables works, but that is not exaclty what I would like to do. Here's what I'm looking to do. 1. Table A updates daily. 2. I want to use a query to Copy all data from Tabl...
Anonymous , You do not need to copy, Just Click on table B and then use the append option in power query that should do. Make sure column names are same
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
@amitchandak I don't belive this is answering the question that I'm asking unless I misunderstand you. Can you be more specific on the steps you think will answer the question?
If I append Table A to Table B, the data in table B will change whenever the data from the source (Table A) changes. What I want is static data to serve as a record of data that exists in Table A upon every refresh of Table A.
Please let me know your thoughts, and please be specific in the steps if possible. "Append as New" or just "Append"?