Building apending table from power query issue

[Misteruniverse]

Hi friends,

I tried to build a table with historical data through power query , tried hard but not able to build the table with historical data. power query keeps updating same row again and again. I have attached the excel file.
Live data sheet fetch the data and required data format is mentioned in final sheet.

please help me to build the final data table automatically from power query .

[alansidman]

Because you are connected to a web site that is continually changing, every time you refresh the data it updates to the latest information. If you want historical data to remain static, break the link after you make your initial download.

[Misteruniverse]

ok, how to automate that , please help

[alansidman]

With your file open, click on Queries and Connections. Delete the Connection.