Store old data upon refresh?

I had this question to.

I finded an ugly solution, but works for smalls data sets and in cases that you don't need to refresh frequently.

Basicly I:

1 - use an Excel file to Query my dataset, and name the Query "New",

2 - add a column "Updated in" with the formula "DateTime.LocalNow()"

3 - Create a table "Store", in my workbook to store my dataset with the mase extra column (Updated in), this table is not a query and has no rows (yet).

4 - Query my Own workbook to get the table Store (this Query will be only connection).

5 - Then in the Query "New" I append the query "Store"

All is set, now all I need to do is refresh my query "New", Manualy Copy the inteirer table, and paste into my Table Store (not the query, the real deal).

If I need the history by month I need to Do this last step evry Month, as I say, is ugly but works.
To make this more fast (sinze in my case I need to have the history of by day) I create an macro that refreshs my data, copy and paste, saves and close my workbook.
The Table Store will be connected in my Power BI.