In this Data Engineering episode, I covered how to connect to files resident in on-prems folder and transform the data using Factory Data Factory dataflow gen2 and publish to the new SQL Database for downstream analysis in Power BI