Forum Discussion
Solved
Gen2 Dataflow load to Lakehouse error - Can't insert null data into non-nullable column
I am trying to load a handful of tables from Business Central to a Fabric Lakehouse using Gen2 Dataflows and the BC connector but keep getting the following error. For reference, I have the dataflow ...
Please check this section of the documentation around cases like this:
Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn
Hi, jsrichards
try the process again form the start. make sure your source has the allow null option selected. I am loading data using gen2 that have null values and it is refreshing successfully.
Where is this 'allow null values' checkbox? Don't see it anywhere?