Forum Discussion
Solved
Fabric Dataflow Gen 2
I have one source account file from which I’m deriving 12 different tables in Dataflows, all of which are driven from the same account file. For example, in the account file ...
Did you maybe forget to specify the column types before sending the results to the Lakehouse?
Hi negideepika06 , Thank you for reaching out to the Microsoft Community Forum.
Since you’re expanding nested JSON, it’s worth validating the last few steps of those 4 queries to ensure they’re actually returning populated records and not empty structures. Also, double check the column to destination mapping in the Lakehouse, as mismatches there can result in all null writes without errors. Write one of the failing queries to a new table, if it still comes out NULL, the issue is in the transformation layer, if not, it’s in the Lakehouse write/mapping.