Power Query Append Tables

[JajatiDev]

Hi,

I have 3 Excel tables in 3 sheets of the workbook that are appended to create a master table. However, I'm facing an issue where the same data keeps getting appended if the refresh button is pressed more than once. Please advise how can I prevent the master table from getting appended again and again with the same dataset.

Regards,

Dev

[v-cgao-msft · Accepted solution]

Hi @JajatiDev ,

1. Check if your final query is included in the append: If your final query is included in the append, it might be getting loaded into Power Query again, causing duplication.

2. Use 'Append Queries as New': Go to 'Edit Queries' and select your first query then go to 'Home > Append Queries as New'. Choose your 3 tables (Query1 , Query2 and Query3) and hit OK. This should exactly append the two queries, without repeating any duplicates.
Append queries - Power Query | Microsoft Learn

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum