Append table refresh not working properly

[Alianza]

I have a workbook with 4 worksheets which I appended using Power Query, and then create a pivot table from the appended table. When I add a new record to one of the source tables and refresh the append table, the refresh ads the new record twice. How can I correct this, -- Thanks

 

[sandy666]

maybe try to filter the source to the these four tables only
would be fine to see your excel file with your method and M. Post a link to the shared excel file via onedrive, googledrive or any similar
with your actual information I can do nothing

 

[Alianza]

I deleted the appended worksheet and all the queries then rebuilt them from scratch and now it works properly. However, the previous time I built the queries and the append table it worked at first and then it broke. I hope that doesn't happen again, but I'll see. If it breaks again I'll post a follow up and will share the file. Thanks.

 

[sandy666]

You are welcome