Forum Discussion
mcrreddyt
Microsoft Employee
2 years agoNot able to add 2 additional columns into Dataflow Gen2 as the source excel file has 2 columns added
I am not able to add 2 additional columns into Dataflow Gen2 as the source excel file has 2 columns added for the existing Dataflow. The data flow has failed and not picked the additional 2 columns. ...
jwinchell40
Resolver III
2 years agomcrreddyt - After you pulled the 2 columns into the Dataflow UI, did you remap the Lakehouse connection and table? I've had it pick-up new columns before going through it that way. In my case though, I'm doing an "overwrite" vs an "append" so that may cause different behavior.
I pretty much use the Notebook utilities to modify anything structural with the Lakehouse; like adding columns or repartitioning. Its faster.