Combinez 288 fichier en quelques clics dans Power BI

📥 DOWNLOAD THE FILE to practice alongside me: https://www.datacoach.ca/register/com... 📊 Get started with Power BI (free course): https://datacoach.kit.com/power_bi_intro In this tutorial, I show you how to combine 288 CSV files in just a few clicks using Power BI and Power Query. The unique feature of this challenge is that each file contains several header rows that must be ignored to properly exploit the data. You will learn: How to import multiple CSV files from a folder How to use Table.Skip to ignore the first rows How to properly promote headers with PromoteHeaders How to extract information (country) from the file name How to automate the entire process to save valuable time This tutorial is perfect for beginners and advanced users alike who want to improve their Power Query skills and optimize their workflow. ⏱️ CHAPTERS: 00:00 Introduction and Challenge Overview 00:34 Downloading and Extracting the File 01:17 Problem Analysis 01:56 Importing Data into Power BI 03:10 First Attempt at Combining 04:57 Fixing the Import with Table.Skip 06:39 Promoting Headers with Table.PromoteHeaders 07:53 Extracting the Country from the Filename 09:12 Final Result and Conclusion 📊 Do you work with Power BI and Power Query? Subscribe to my channel to discover more advanced tips and techniques!