Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Dataflow Gen2 update method replace appends data

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 ol...
Admin
Anonymous's avatar
Anonymous
Not applicable
1 year ago

 

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's avatar
    v-sgandrathi
    Community Support
    1 year ago

    Hi Anonymous,

     

    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's avatar
      v-sgandrathi
      Community Support
      1 year ago

      Hi Anonymous,

       

      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's avatar
        v-sgandrathi
        Community Support
        1 year ago

        Hi Anonymous,

         

        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.