Forum Discussion

madrid's avatar
madrid
Icon for Helper I rankHelper I
3 years ago

Delete last step in dataflow table transformation was generated automaticly

Hi there,

In a table in the dataflow with Incremental Refresh "On", I saw a last transformation step generated automaticly (TableName-xxxxx-autogenerated-for-incremental-refresh). I wonder what happen if I delete this this last step ?

And, if I want the data in that dataflow to have a full refresh again, which is the most practical way ?

 

Thank you,

madrid

 

Dataflow

2 Replies

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi madrid ,

     

    Could you please provide me the screenshot because I may not understand the step you mentioned?

    (TableName-xxxxx-autogenerated-for-incremental-refresh).

     

    About you want to have a full refresh again, only need to turn off the incremental refresh and turn on the schedule refresh.

    For more information about the incremental refresh, you can refer the documentation below:

    Using incremental refresh with dataflows - Power Query | Microsoft Learn

     

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • madrid's avatar
      madrid
      Icon for Helper I rankHelper I
      3 years ago

      Hi v-yinliw-msft 

       

      Here is the screenshot, the step I mentioned is at the bottom of transformation steps.

       

       

      Thanks!