Importing Excel files from a folder: Power Query metadata magic
If you are already importing Excel files from folders using Power Query, it is important to carefully examine the metadata that Power Query requests. This will allow you to limit the imported data to the relevant information before you begin further processing. Have fun! 😉
📊 SAMPLE FILES 📊
The sample files used are available free of charge to my newsletter subscribers: http://eepurl.com/cmkOEz
🎓 VIDEO COURSE 🎓
My comprehensive Power Query beginner's course with 160+ videos – everything you need to know about data import and automation:
https://myablefy.com/s/ssbi-blog/powe...
👨🎓 TRAINING 👩🎓
My Power BI online training courses: https://ssbi-blog.de/power-bi-schulungen
🥷 CONSULTING 🥷
Want to book a consultation? Here's the link: https://calendly.com/ssbi-blog/15min
📹 CONTENTS 📹
00:00 Preface
00:24 Intro
00:33 Hello + Topic
00:48 Sample Data
01:46 Metadata of the Files in the Folder
12:59 Importing All Sheets of a File
15:04 Metadata of the... Objects within the file
20:20 Marker 8
21:58 Closing remarks
📃 FURTHER SOURCES 📃
Power Query recognizes 3 Excel objects: https://ssbi-blog.de/blog/business-to...
🙋♂️ CONTACT 🙋♂️
Website: https://ssbi-blog.de/
LinkedIn: / lars-schreiber-power-bi
Twitter: / schreiberlars
🤿 SETUP 🤿
https://kit.co/LarsSchreiber/office-s...