http://www.sqlservercentral.com/blogs/dknight/2013/08/08/extracting-data-from-multiple-files-with-power-query/

Printed 2014/07/29 05:57PM

Extracting Data From Multiple Files with Power Query

By Devin Knight, 2013/08/08

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..

Step by Step

image

image

image

image

image

image

Hope this helps!


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.