Category: Power Query

In this post, we are looking at using Power Query to import all the files in a folder.  We give Power Query a folder path, click a few buttons and it will import and combine all the files into a single table.  That’s powerful stuff, right!  If we want to add another file into the Read More

Data doesn’t always come in one single file, or from one download.  We often have to find a way to stitch multiple files together so that we can use it as if it were a single data source.  This might be cost center reports, monthly data extracts, product profiles, survey data, etc.  Basically, it applies Read More

We’ve looked at a few transformations already in this Power Query series, but now we are going much further and look at the transformations available in the main Power Query menus.  We can’t cover everything in this post; there are just too many options available.  Also, some of the more detailed transformations will be included Read More

As Power Query records the transformation steps, it includes many hardcoded values within the M code.  For example, if we filter a column to select all values greater than 50, the 50 will be a hardcoded value.  Or if we import a CSV file, the file path is hardcoded into the query. What if we Read More

In this part of the Power Query series, we will be taking a quick look at the Close & Load options.  So far, we have only used the default option which loads the output of the query into a new worksheet.  But there are plenty of other options we could use instead. We won’t get Read More

In this part of the Power Query series, we will look at how to edit queries.  We’ve seen a small piece of this in a previous post, but now we’ll go a lot deeper. Download the example files It may be tempting to just read the text below, but you will retain the information much Read More

In the previous part of this Power Query series, we took a first look at how to import data from various file formats and load it into Excel.  Now, in this part, we move on to consider how we can refresh the data, which enables us to build a query once and use it over Read More

OK, Let’s get started with Power Query.  The first thing we need to do is import some data.  As this is our first real look at Power Query, we are going to use this as an opportunity to explore the user interface. This post is structured into two parts: Using data in the same workbook Read More

The party would already be in full swing; I was going to be late.  Not fashionably late, just late. When I finally arrived, rather than the usual “What time do you call this?“, I received the “Hey; you made it, that’s amazing. It’s great you could come. Let me show you around“. Nobody looked down Read More