Forum Discussion

sammy1998's avatar
sammy1998
New Member
1 year ago
Solved

Issue with Dataflow Refresh from Oracle On-premise to Lakehouse - MashupException

Hello Community, I am currently facing an issue when using Dataflow in Fabric to load data from an on-premise Oracle source into a Lakehouse. My workflow is as follows: I created several queries i...
data engineering
lakehouse
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi sammy1998,

     

    The Delete rows in destination table option is available only in Dataflow Gen1, not in Dataflow Gen2

    If you're using Dataflow Gen2 Use a Pre-step to Drop the Table Before Replace.

     

    Regards,

    Vinay Pabbu

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi sammy1998,

 

Thank you for reaching out to Microsoft Fabric Community Forum.

 

This is expected behavior in Fabric. When a Dataflow tries to overwrite an existing Delta table in the Lakehouse, it can fail due to how Delta handles table state and locking. To avoid this, set the destination option to "Delete rows in destination table" instead of "Replace entire table." This ensures a clean refresh without triggering the mashup error.


If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!


Regards,
Vinay Pabbu

  • sammy1998's avatar
    sammy1998
    New Member
    1 year ago

    Hi Anonymous ,
    In Dataflow Gen2, I don’t see the “Delete rows in destination table” option—only “Append” and “Replace” are available. Is there any way to enable this option or another recommended workaround?

    Thank you!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi sammy1998,

       

      The Delete rows in destination table option is available only in Dataflow Gen1, not in Dataflow Gen2

      If you're using Dataflow Gen2 Use a Pre-step to Drop the Table Before Replace.

       

      Regards,

      Vinay Pabbu