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-4 (out of 4)
Posted by Andy Brown on 04 January 2018
If you get data in pivot (two-dimensional) form, you can unpivot it to get the underlying rows, and hence produce charts and visuals. This blog shows how!
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.