Forum Discussion
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...
I'm seeing the same issue.
Sounds like a bug introduced in the dataflows, that they check for nullable columns source<>destination instead of actually checking for the occurrence of null-values in the source.
Anyone had any luck resolving it? My destination table needs the column to be not null.
Also just started getting this issue when trying to re-publish an already functioning Dataflow Gen2. The source field (SQL Server accessed via recently upgraded Data Gateway) is a Primary Key and thus not null. So it's not clear what the system is checking.