[Doug McLean]

the real key to using Power Query is a consistent output of data.

Take the time to learn how to set up a proper BatchConfig output file with exactly what you want.
I talked about planning properly in my presentation, because that is the very first thing you need to do. Figure out what you want to do, figure out where you are, then figure out how to get there.

I have one slide in my presentation that says how data without context is just noise. We can generate so much data now in construction that we have to learn how to filter out all of the noise and get to what we really want.