Forum Discussion

mali130's avatar
mali130
Helper I
3 years ago

Manual Refresh duplicating the rows

Hi Gurus,

 

I am having this issue when i am doing manual refresh it is duplicating my rows, I did not change any thing. Can you please advise asap.

 

Need Help
Show and Tell

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    mali130 , Open power query and check the steps. Are there steps like merge or append that are doing that

     

    Otherwise add the table again with a new name, refresh this table a few times, and check. If it is working fine. Change this table to have the same columns names and types.

    Then Take the code from the Advance editor and replace it in the old table

     

     

    Very similar step done here

    Change Connection from One source type to another Source Type: https://youtu.be/nwYJgG2hmd0