On of the most exciting updates for me in Microsoft Fabric was Gen2 Dataflows that can write to to a table. This video walks through taking a folder of files and making a table. Also includes a cool date transformation.

Blog post https://hatfullofdata.blog/microsoft...

Table of Contents
00:00 Introduction
00:31 Create Dataflow
02:17 Combine files
03:40 Fix the Date from one format to another
05:42 Add Destination to the dataflow
07:42 Publish Dataflow