Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: A Summary Taster

24 March 2017

At the end of that article, I had made some changes to a query of mine, ‘ACCT_Order_Charges_with_Group’. I will be making more changes, but to avoid causing problems to the grouping query, I will create a copy of the query.


Power Query: Taking (Away) Steps for Efficiency

22 March 2017

Welcome to our latest Power Query blog. Last time we looked at M language syntax in a simple query. Today I add some code to operate on each row in a table and show how bulky code can be simplified.


Power Query: M-Body Personified

15 March 2017

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


Power Query: Unlimited Importing of Non-Delimited Text Files

10 March 2017

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.


Power Query: M-Powered

8 March 2017

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.


Power Query: Time for Refreshments

1 March 2017

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.


Power Query: a World (Wide Web) of Possibilities

22 February 2017

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…


Power Query: Two (Queries) Become One

15 February 2017

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.


Power Query: Models Have Relationship Issues Too

8 February 2017

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.


Power Query: (Data) Model Building

1 February 2017

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.


Newsletter