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 by editing it manually, but what I am going to show you today is changing […]
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. […]
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 […]
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 […]
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