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've figured out the solution that lets you keep your destination table's field as INT NOT NULL.
1. In the Power Query editor, set the data type to Int64.Type
2. Select Transform > Mark as key
3. Change the last parameter from false to true
Thanks for that suggestion. Do you also have a workaround for VARCHAR(??) NOT NULL fields?
I don't seem to be getting the same issue in this case. What error are you seeing when you try to run the dataflow? Have you tried the steps listed by Anonymous in their last reply?