Blogs from Wise Owl on Power Query in Power BI - Excel

Showing blogs 1-2 (out of 2)

Loading live web data into Excel without writing VBA code to scrape HTML

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

Tags:   Excel | PowerPivot    |    Power BI - Excel | Power Query

Combine all the files in a folder into a single table using Power Query

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.

This page has 0 threads Add post