Microsoft Fabric: Dataflows to Convert CSV Files to Tables

In this video, we revisit a topic from an earlier tutorial - converting CSV files into tables in a Lakehouse. Specifically, we tackle a common limitation when working with CSV files that have spaces in column names. We guide you through a simple yet effective workaround using Dataflows Gen2. Join us as we provide a practical solution to enhance your data workflow. 📊 What you'll learn: - Limitations when turning CSV files with spaced column names into tables. - Step-by-step walkthrough of an effective workaround using Dataflows. - Correcting column names in bulk using Dataflows. ⏱️ Timestamps: 00:00 - Introduction 00:41 - Issue with CSV files that have spaces in column names 03:27 - Create a Dataflow Gen2 to solve the issue 06:10 - Remove spaces in column names in bulk 🔗 Useful links: Lakehouse documentation: https://learn.microsoft.com/en-us/fabric/data-engineering/create-lakehouse Dataflows Gen 2 documentation: https://learn.microsoft.com/en-us/fabric/data-factory/create-first-dataflow-gen2 🤝 Let's Connect: LinkedIn: https://www.linkedin.com/company/centida/ Website: https://centida.com/ ​​Centida GmbH 34 ​​Kernenhofstrasse​, Oberkirch​​ 77704, ​German​​y Email: [email protected] #MicrosoftFabric #PowerBI #Lakehouse #Dataflow #Training 👍 If you found this video helpful, please give it a thumbs up, and consider subscribing to stay updated with our series. Your engagement helps us create more valuable content for the community.