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
Begin your Power BI learning now - How can Matt help?