Gen2 DataFlow inserts null values into Warehouse

Hi FabricNZ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

After reviewing the issue of Dataflow Gen2 inserting null values, I reproduced your exact scenario and used custom column to create value 1 column.

I tried both replace and append, the data has successfully reached the destination table. Try to check if you have made any errors in dataflow gen2 and retry it.

For reference, please go through the below screenshots:

First, open your workspace in your Fabric account, then select Warehouse.

Next, open the warehouse, select the 'get data' option, and then click on 'new dataflow gen 2'.

After clicking on the Dataflow Gen2, select the 'Get Data' option. It will prompt you to provide sample data through Excel.

After importing the data and adding the custom column to the table using the custom column option, select the destination at the bottom of the page and click on the warehouse.

Please use the same warehouse, name the table Facttable2, select warehouse(kannawh), and then click next.

Please select the Append option, then click Save Settings, and publish it.

After opening the warehouse and refreshing the table, please refer to the output in the image below.

If you have any further queries, please feel free to reach out to us we will guide you accordingly. If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you.