Get data from folder 🔨 / Combine multiple Excel files 🔧
HTML-код
- Опубликовано: 11 июл 2024
- 📢 Welcome to BI-Lingual Analytics 📢
Have you ever wondered what's the best practice to quickly import multiple #Excel files to #PowerBI ❓
Today's video is all about 🔨 Get Data From Folder 🔧 or in other words how to import in bulk...
Have a good one,
Roland
Content
0:00 - Intro
1:26 - Example 1 - Simple import
4:22 - Example 2 - Different sheet name
6:01 - Example 3 - Unexpected file type
6:42 - Example 4 - Filter out files
7:42 - Example 5 - Different column name
9:31 - Example 6 - New column
11:10 - Final thoughts
💪 New videos coming every Tuesday 🤹♂
📝BLOG POST: bilingualanalytics.com.au/get...
📄 WEBSITE: www.bilingualanalytics.com.au
🎬 MORE VIDEOS:
How to prepare for the DA-100 Exam - My journey, learning materials & what to expect - Power BI Tips - • How to prepare for the...
Facebook Data Visualization in Power BI 👀 - • Facebook Data Visualiz...
Power BI & Power Automate - How to automate reporting process - • Power BI & Power Autom...
▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - / bilingualanalytics
Subscribe - / @bilingualanalytics
ABOUT ME: bilingualanalytics.com.au/abo...
📍 - Sydney, Australia
📽 GEAR:
📷 - Canon EOS 200D
🎙 - Audio Technica AT2020
🔦 - Neewer 18” Ring Light + Neewer 2 Pack Dimmable
🎧 - BOSE QC35
🖥 - 2x ASUS VC279H
💻 - AMD Ryzen 3600, Gigabyte X570, GTX1650, G.Skill 32GB RAM
Music: www.bensound.com
#PowerBI #BI-LingualAnalytics #BulkImport #CombineFiles #BusinessIntelligence #DataScience #Data #DataAnalytics #Excel #Analytics #BI Наука