Forum Discussion

Mrizzo21's avatar
Mrizzo21
Frequent Visitor
1 year ago

Gen2 Dataflow Started Failing - Nullable Issue

First time positng to the Fabric Community, but this community has been a HUGE resouce for me in all my work, so thank you eveyone.  I have a dozen or so Gen2 Dataflows that pull from a SharePoint l...
Dataflow
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Mrizzo21 ,

 

You can try the following:

  • First, make sure that the source data does not contain any null values for the VARCHAR fields. You can set default values for these fields in the source data to avoid null values.
  • Second, before loading the data into the target table, you can transform the data to replace null values with default strings. This can be done using a data conversion tool or in a dataflow query.
  • Finally, error handling is implemented in the dataflow to catch and handle null values during data loading.

 

Best Regards,
Adamk Kong

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