Forum Discussion
Resolver Iupsert option missing in copy data activity
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
Microsoft EmployeeHello 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
Resolver IUnfortunatly I don't want to import the data.
the entire idea is to not duplicate the data and not over processing the data.
I will do differently for now, but any idea when the upsert will be available?
Hi Jerome22
Did you check this link: https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-setup-incremental-refresh-with-dataflows-gen2?
This is equivalent to upsert condition.Hi Jerome22
Currently we do not have any update regarding the Upsert option availability in Copy data. But the incremental refresh in Dataflow Gen2 is on roadmap.
For more information please refer to this link:
https://learn.microsoft.com/en-us/fabric/release-plan/data-factory
Hope this helps. Please let me know if you have any further questions.