In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time or effort. If you’re still learning the basics of Power Query please refer back to an earlier post here.
This demonstration will show you how to use Power Query to scan a file folder to search for a set of files to load. Then load the contents of multiple files all at once and use transformations to format the data appropriately..
Hope this helps!