POWER BI BLOGS
POWER BI - EXCEL BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Power Query in Power BI - Excel
Showing blogs 1-2 (out of 2)
Posted by Andy Brown on 21 August 2017
Need to get tables of data into Excel from a website? There's no need to write lots of VBA code to scrape the site - just use Power Query to create a live link to the relevant page(s).
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.