Dataflow Gen2 update method replace appends data

[RyanAdvisor]

My Dataflow Gen2 is not working as expected. I have selected the Replace update method, but instead of replacing the existing data in my warehouse table, it is appending new data while keeping the old data intact. This results in duplicated records rather than a full refresh.

[RyanAdvisor]

Sadly they didnt. Replace should replace all data in my table right? So it shouldnt be possible that my data got appended but for some reason it did.

[v-sgandrathi]

Hi @RyanAdvisor,

Both replace and append methods are effective for schedule refresh or incremental refresh.

To assist you further, could you please provide more details. Specifically, could you clarify if you're performing a full data refresh or just publishing changes to the table?

Thankyou.

[v-sgandrathi]

Hi @RyanAdvisor,

I wanted to follow up on our previous suggestions regarding issue. We would love to hear back from you to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thanks for reaching out to the Microsoft Fabric Community forum.

[v-sgandrathi]

Hi @RyanAdvisor,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thanks for reaching out to the Microsoft Fabric Community forum.

[v-sgandrathi]

Hi  @RyanAdvisor,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If you need any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

[v-sgandrathi]

Hi @RyanAdvisor,

May I ask did your query got resolved! If @suparnababu8 response helped you out, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[suparnababu8 · Accepted solution]

Hi @RyanAdvisor 

Please refer the below accepeted solutions it  might helps you.

https://community.fabric.microsoft.com/t5/Service/Dataflow-Gen2-update-method/m-p/3287306

https://learn.microsoft.com/en-us/fabric/data-factory/dataflow-gen2-data-destinations-and-managed-se...

Thanks!