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

Showing blogs 1-4 (out of 4)

How to use an unpivot transform in Power BI Desktop (or PowerPivot) Query Editor

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!

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

How to write an M formula to convert Julian dates using Power Query

Posted by Andy Brown on 08 December 2017

This short blog explains how to convert Julian dates to "normal" ones, and how the formula used actually works!

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

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