Hi, I want solution in Power Query. I have master data file which I need to append new records daily basis, I have built Power Query(PQ) solution for data massaging which will be finally appended into master data sheet. I wanted to keep appending data on rolling basis in same master file. Currently when I refresh PQ, it only appends current day's data in master file tab, yesterday's data is overwritten.
Please advice.

Also, Anyone knows appending data in different excel workbook using power query function, let us know.

Thanks and Appreciated!
Please advice.
Thanks!