There are some valid reasons why you may need to change the names of all the columns in a table for use in Power BI. It is of course possible to change each column name …
Renaming all the Columns in a Table at Once using Power Query (M Language) Read More
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 …
Import the First Sheet in a Workbook with Power Query Read More
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 …
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; …
Matt shares lots of free content on this website every week. Subscribe to the newsletter and you will receive an update whenever a new article is posted.
Excelerator BI | Expert Power BI Training | © 2020