Forum Discussion
Solved
Questions with appending data
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!
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;
Regards,
Hasham
1 Reply
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;
Regards,
Hasham