Power Query: The same table getting appended with every refresh causing duplication

[jajatidev]

Hello Everyone,
I need guidance with an issue I'm confronted with in power query.
I have 3 tables in Excel that are appended using power query. The issue I'm facing is after updating the tables with fresh data and refreshing the query. The consolidated table gets updated however the same table gets appended the number of times refresh is hit causing duplication of data.
Please advise how can I prevent this duplication irrespective of the number of times the report refresh is hit.

Thanks and Regards,
Dev

 

[GraH]

Would need to see each query statement. You might apply an extra append somewhere?

 

[Guitarmageddon]

Hello Everyone,
I need guidance with an issue I'm confronted with in power query.
I have 3 tables in Excel that are appended using power query. The issue I'm facing is after updating the tables with fresh data and refreshing the query. The consolidated table gets updated however the same table gets appended the number of times refresh is hit causing duplication of data.
Please advise how can I prevent this duplication irrespective of the number of times the report refresh is hit.

Thanks and Regards,
Dev

Pardon me if I cant link to youtube, but are you struggling with the recursion issue he mentions here with the table trying to re-upload itself?

 

[jajatidev]

Thank you. I was able to identify the issue.

 

[smozgur]

Thank you. I was able to identify the issue.

Good to hear you identified the issue.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.