Here is a how-to for importing Excel files from a folder using Power Query (Get and Transform). It’s fairly easy to do.
HOWEVER, in this example, I’m sharing a folder with someone who starts putting goofy stuff into the folder and they break the Power Query query and the process. Now what?
One move is confrontation. Tell the person to ” knock it off!” Another move is to modify the query.
Check out the video. Please comment. Share your thoughts. Ask questions.
The song in the video is “Quintal do Céu” by Seu Jorge
For an intro to Get & Transform (Power Query) try my Lynda.com course:
My book: Guerrilla Data Analysis 2nd Edition
My old blog: http://datascopic.net/blog-2-2