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
FabianSchut's avatar
FabianSchut
Solution Sage
1 year ago

Hi Mrizzo21,

 

it seems to me that a null value of the ID column has entered your input data and is giving the error when you refresh the data. The table in the destination is fixed with not null for the ID column. If there always need to be a value for the ID column (which makes sense for an ID column), you could remove the rows where the ID column is null. If you would like to allow null values, you should delete the destination table and recreate it.

Mrizzo21's avatar
Mrizzo21
Frequent Visitor
1 year ago

Hi FabianSchut, the problem is that I've checked the output queries, line by line, and there are no NULL values being generated anywhere. I've tried looking though the JSON code as well. 

  • BJD's avatar
    BJD
    New Member
    1 year ago

    This is happened to me as well for the first time today.  I have no values that are null and have also filtered to remove empty just in case.  It is the column that will be used as the primary key field in SQL.