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
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