Archive - Blog Posts on M Language

Import First Sheet with Power Query
Import the First Sheet in a Workbook with Power Query - My series about common patterns for loading data using Power Query received quite a lot of interest over the last few weeks.  You can review those articles in the links below Combine all files in a folder with Power Query. Load the Latest Version of a File with Power Query. Combine all sheets in a […] Read More
Combine All Sheets in a Workbook with Power Query - There are quite a few different common business scenarios where you get data in the form of a file on a regular basis.  The 3 common patterns I use most often are. Each day/month/year you get a new file containing incremental data.  All the data in all the files need to be combined and loaded. […] Read More
Best Book for Learning the M Language - Late in 2018 there was a new Power Query book written by Gil Raviv called Collect, Combine and Transform Data Using Power Query in Excel and Power BI.  That’s a bit of a mouthful actually; maybe the title was influenced by the same people that call Power Query “Get and Transform” in the Excel menu?!   […] Read More