Power Query : comment combiner tes fichiers et tables proprement (+ le piège du Merge)

Want to go further and master Power BI from A to Z with practical examples from real-world projects? This training is available now as a launch offer. 👉 www.boubacar-analyst.mychariow.shop/formation-power-bi-pratique Two operations that every Data Analyst uses on a project and yet, an invisible error can throw off all your calculations without displaying a single error message. In this video, I cover everything: → Append (Add queries): stacking multiple tables with the same structure → Merge (Merge queries): joining two tables using a common key → Bonus: automatically loading all files from a folder in a single query — no more copy-pasting between files → The 4 types of joins and when to use each → The silent join key error that skews your totals I encountered this error on a project: a text column on one side, a number on the other. Power Query doesn't report anything, but the rows don't join. Result: incorrect figures in your report without anyone knowing. ⏱️ Timestamps 00:00 – Introduction 00:47 – The 2 operations and their use cases 01:35 – Definitions: Append vs. Merge 02:45 – Append Demo (Adding queries) 04:40 – Bonus: Automatically loading all files in a folder 08:21 – Merge Demo and the 4 types of joins 12:20 – The error that throws off your calculations without warning 13:25 – Pro tip 14:00 – Conclusion 🔔 This video is part of the Power Query ETL series. Subscribe so you don't miss the next one. #PowerBI #PowerQuery #Append #Merge #DataAnalyst #ETL #BusinessIntelligence #Excel #Training #PowerBIFrench