Exceldateien aus Ordner importieren: Power Query Metadaten-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...