EXCEL + BLOGS
POWER BI - EXCEL 2013 BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Power Query in Power BI - Excel 2013
Showing blogs 1-1 (out of 1)
Posted by Andy Brown on 21 February 2017
Sure, you can use Power Query (or Get & Analyze, as it's now called) to load and transform data, but did you know you can loop over all of the files in a folder, combining their data into a single set of results? This blog explains how to do this for CSV files, and gives a lead for how to proceed with Excel ones.