Forum Discussion
Solved
Where to modify destination from replace to append
Hi there, I am busy following this method so I can do incremental refresh to a Lakehouse: https://www.azureguru.net/datalake-incremental-updates-using-microsoft-fabric-dataflow-gen2 At one p...
Hi all, in case anyone in future experiences this issue, you need to do the following:
- Remove the default destination. You can delete it.
- Add a new default destination. Don't choose the default lakehouse you are in - instead pick from the options below, one of which says "Lakehouse".
- Follow the process. At one point, you get the option to choose a destination target. Here you must pick from New Table or Existing Table. Pick Existing Table. Drill down in the display options to find the table you wish to use. Click next.
- You now get given the option to Append or Replace. Obviously you pick Append at that point and there you go! Click Save settings and you will now append rather than replace the data in the table.
- Remove the default destination. You can delete it.
Hi all, in case anyone in future experiences this issue, you need to do the following:
- Remove the default destination. You can delete it.
- Add a new default destination. Don't choose the default lakehouse you are in - instead pick from the options below, one of which says "Lakehouse".
- Follow the process. At one point, you get the option to choose a destination target. Here you must pick from New Table or Existing Table. Pick Existing Table. Drill down in the display options to find the table you wish to use. Click next.
- You now get given the option to Append or Replace. Obviously you pick Append at that point and there you go! Click Save settings and you will now append rather than replace the data in the table.
Hi DataSkills ,
We really appreciate your efforts and for letting us know the update on the issue.
Please continue using fabric community forum for your further assistance.
If this is the solution that has worked for you please accept your reply as solution so as to help other community members who may face similar issue in the future.
Thank you,
Menaka Kota.
