Power query creating duplicate rows after merging. The duplicate rows double each time I refresh the data.|Power Query|Excel Forum|My Online Training Hub

Hello All,

I'm getting duplicate rows every time i refresh my data. It doubles every time i hit refresh.

Following are the steps that i followed

1. I created a query from an excel table which was an existing query. 

2. I deleted some columns that i did not need.

3. I pivoted the data based on Sales order# and Price to get a unique list of Sales orders and aggregate price.

4. I loaded it into a new sheet. (Query name = summary)

5. I added 3 columns to the right hand side of the table called "comments", "actions" & "updates".

6. I made a connection of the table which includes the 3 new columns. (Connection name = self ref)

7. I edited "summary" and merged it with "self ref"

8. I expanded the tables to merge the 3 new columns to "summary"

9. I hit save and load.

The final product looked ok, and the comments are dynamic as i expected. However one sales order# which had 2 ship by dates and hence appeared twice in the table started doubling every time i hit refresh. I managed to solve this by editing the query and adding remove duplicates to the end. This stopped the doubling and removed the duplicates. However when i started entering comments and refreshing again a few other rows along with the previus culprot began to double again.

I am a beginner with power query, your inputs will be appreciated. 

Thanks

Stan