Forum Discussion

pbi_taken's avatar
pbi_taken
Helper I
2 years ago
Solved

Incremental refresh og selected refresh using data pipeline

Hi,    Wondering if anyone has done this successfully?   I'm using the copy activity to get data from my on-prem sql server. I would like to not overwrite my entire table on each refresh.  I eac...
Need Help
Pipelines
rubayatyasmin's avatar
rubayatyasmin
Community Champion
2 years ago

Hi, pbi_taken 

 

You can use this upsert option to get your desired result. 

 

 

  • pbi_taken's avatar
    pbi_taken
    Helper I
    2 years ago

    Hi rubayatyasmin ,

     

    Thanks! Maybe my question was a little misleading. My destination is a Lakehouse and with that it does not give me the option of upserting. 

    Could an expression builder solve this, and if so, I do not know..