In order to see some M language in action, I return once again to the query I created in Two (Queries) Become One.

As a programmer, I was often asked to produce delimited versions of reports which could easily be picked up by Excel. Whilst it is possible to clean non-delimited files in Excel, it’s a laborious and repetitive process, which is why it made more sense to pay for a programmer to automate it.

Welcome to our new Power Query blog. The built-in functionality of Power Query means that many tasks can be accomplished at the press of a button. But what if there isn’t a button for what needs to be done? Then it’s time to delve into M, the programming language behind Power Query.

Welcome to our new Power Query blog. So far I have shown that a variety of data can be extracted and loaded into queries and worksheets. Today I look at how to keep that data current by triggering automatic refreshes.

Welcome to our new Power Query blog. I have already shown how to extract and transform data from CSV files, folders and Access database tables. Today, I look at a potentially huge source of data – extracting data from the web…

Welcome to our new Power Query blog. I have previously shown how to extract a database table and load it into the Excel data model. Today I create a query for a second table and show how queries can be merged.

Welcome to our new Power Query blog. In the last two blogs I established that Power Query is an ideal starting point to create the Excel model for use by Power Pivot, and I demonstrated how a table can be added to the Excel model and opened in Power Pivot. Today I look at whether changes to the model should be done in Power Query or Power Pivot.

Welcome to our new Power Query blog. Today I extract a table from an Access Database and load it into the Excel data model ready for use by Power Pivot.

Welcome to our new Power Query blog. Today I look at the relationship between Power Query and Power Pivot.

Welcome our new Power Query blog. Today I extract information from a file name.