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

jajatidev

Board Regular
Joined
Jul 29, 2016
Messages
78
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Would need to see each query statement. You might apply an extra append somewhere?
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,909
Messages
6,175,312
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top