[Doug McLean]

a lot of people don’t know about it (and even more don’t realize its free)
It really is one of the best tools out there for repeated data washing.
Just mind your steps, because it can error out easily. Its best to have a nice consistent output of data so that your columns names are all the same all the time. That is one big key to using Power Query. The other is a consistent name of your markup summary, which a BatchConfig file will allow you to do. This will allow you to make your file path a bit more dynamic if you like