How to Import Excel Files with Power Query; BUT there’s a PROBLEM

/in /by

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:

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2