Forum Discussion
Incremental refresh og selected refresh using data pipeline
I think you will need to use Notebook to upsert into Lakehouse.
There is an example of upsert here:
https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/03b-medallion-lakehouse.html
There is an overview of some functions here:
Are you looking to append the updated rows, or are you looking to do upsert (insert new rows and update existing rows with changes)?
If you want to do an upsert, I think you will need to include a Notebook to do the upsert for a Lakehouse destination.
looking to upsert.. append is an option, but not useable in my situation
I think you will need to use Notebook to upsert into Lakehouse.
There is an example of upsert here:
https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/03b-medallion-lakehouse.html
There is an overview of some functions here: