Forum Discussion
Helper INew column added from a Dataflow is not appearing when adding a Destination Source
Thanks. What I ended up doing is creating a staging lakehouse where I copy the data to first from SQL Server and then in the Dataflow, add the source destination into a "production" lakehouse.
Hi christianunr ,
Only tables created from dataflow in the lakehouse can detect dynamic changes in the output of the powery query.
In other words, if you want to detect new columns when mapping columns, you need to select the 'create table' ub dataflow instead of selecting an existing table.
Besides, if you already have a table in your lakehouse that was created by something other than dataflow,
you can also create a new column via notebook.
Best Regards,
Wearsky
christianunrThanks. What I ended up doing is creating a staging lakehouse where I copy the data to first from SQL Server and then in the Dataflow, add the source destination into a "production" lakehouse.