Forum Discussion

Jerome22's avatar
Jerome22
Icon for Resolver I rankResolver I
2 years ago
Solved

upsert option missing in copy data activity

in this documentation : Load data to Lakehouse using partition - Microsoft Fabric | Microsoft Learn we can see an upsert option in the screenshots to load data in a lakehouse. but I'm not able to ...
pipelines
  • HimanshuS-msft's avatar
    HimanshuS-msft
    2 years ago

    Hello Jerome22 ,

    As called Anonymous  , at this time the UPSERT is not avalable . Since you mentioned 
    "for now it's pretty complex to update data in a lakehouse. So for now I'm using the overwrite option, but this causes issues to my users if they are opening a report in the middle of a loading of the data."
    I am assuming that the you are using Direct query for the reports and request you to see you can use the Import option , this is the link : https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
    Thanks 
    Himanshu





Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Jerome22 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi @Jerome22 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

Related content