Forum Discussion
Solved
Read data from Dataverse table via Fabric Dataflow gen 2
Hello All, Good day! I am trying to read data from dataverse tables through Farbic dataflow : https://learn.microsoft.com/en-us/fabric/data-factory/connector-dataverse But getting timeout e...
Looks like this is the same issue as
Gen2 Dataflow load to Lakehouse error - Can't inse... - Microsoft Fabric Community
"
Exception:ExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Message: We can't insert null data into a non-nullable column."i.e., your source\destination target has nulls but the columns are non-nullable.You can mark your source table's columns to nullable to fix this for now. We are working on several changes here that will address the issue - such as defaulting to nullable, and surfacing nullability better in the mapping screen.
BTW, this is clickable to drill into details
Looks like this is the same issue as
Gen2 Dataflow load to Lakehouse error - Can't inse... - Microsoft Fabric Community
"
Exception:
ExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
Message: We can't insert null data into a non-nullable column."
i.e., your source\destination target has nulls but the columns are non-nullable.
You can mark your source table's columns to nullable to fix this for now. We are working on several changes here that will address the issue - such as defaulting to nullable, and surfacing nullability better in the mapping screen.