Forum Discussion

eyeballkid's avatar
eyeballkid
Frequent Visitor
1 year ago

Dataflow fails with Mashup error

Hi, I've created what is probaby the most basic dataflow there is - it connects to the Dataverse and grabs the contact table and creates a copy in a Lakehouse.  The problem is, is that it fails with...
Dataflow
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi eyeballkid 

 

Thank you very much FabianSchut for your prompt reply.

 

In response to the issue of Mashup errors, I've seen several people on the forums suggesting in various cases that highlighting all columns and selecting Keep rows -> Keep errors would solve the problem.

 

This way, you can effectively identify errors in your data. You can try this method, it might help you.

 

Solved: Mashup Exception Expression Error DataFlows 2 Gen - Microsoft Fabric Community

 

Solved: Dataflows Gen2 – Import – Mashup - DataFormat Erro... - Microsoft Fabric Community

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • eyeballkid's avatar
    eyeballkid
    Frequent Visitor
    1 year ago

    Hi Anonymous,

     

    Thanks for the information.  I have tried the Keep Columns>Keep Errors option but trying this on the entire table seemed to time out so I ran it in sections but it generated no errors.

     

    If I take a subset of columns (contactid, firstname, lastname) and run the dataflow it runs to completion, but if I run the entire table, it fails.  I'm at a bit of a loss as to where to go!

     

    Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi eyeballkid 

       

      Thank you for your feedback.

       

      I have some suggestions:


      You mentioned that the data flow was successful in processing a subset of columns, consider checking the remaining columns. If some columns contain a large amount of data, this may cause a timeout.

       

      If there are any transformations or calculations in the data stream, simplify them or remove them temporarily to see if that solves the problem.


      Or try increasing the timeout limit.

       

      I hope this has been of some help to you.

       

      Regards,

      Nono Chen

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.