Questions with appending data

[RoastedPork]

Hi guys, 

I am able to retrieve the fuel price from the public website, but the historic data will be replaced with the new data in each refresh. Table looks like below: 

Just wondering is there any solutions so I can keep the historic data in each refresh and then append any new data? In this way i can do some time series analysis.  Thanks heaps!

[HashamNiaz · Accepted solution]

Hi @RoastedPork !

You can use Append Query Transformation in Power Query (M). Try Append as New Query option. You can follow through the documentation to get started;

Append queries 

Regards,

Hasham