The ULTIMATE Append Hacks in Power Query | Power BI
In this video, I show you can append tables together, either by appending just 2 tables or multiple files from a folder and also how to capture all columns of data, even if new columns show in new files saved in the folder you are picking up the data from.
#powerbi #powerquery #append
📁 Dataset -
https://data.world/deanchereden/super...
🔖c h a p t e r s 🔖
00:00 - Intro
00:24 - Simply append 2 files
04:36 - Append multiple files from a folder
07:57 - Auto add new columns from new files
08:53 - Step 1 - Turn tables into a list
09:52 - Step 2 - Create a list of all columns
11:03 - Step 3 - Append all column names
11:38 - Step 4 - Remove duplicate column names
12:14 - Step 5 - Append all data to columns
💌 My email - [email protected]
🌍 My website - https://www.deanchereden.com
🐦 Twitter - / deanchereden
🎵 Vhsceral - Gimetime https://chll.to/dd82e17f
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - Bliss (A Felicidade)...