Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Questioning Queries

1 March 2023

Welcome to our Power Query blog. This week, I suggest some tips when encountering a query model for the first time.


Power Query: Generating the A to Z of M Functions

22 February 2023

Welcome to our Power Query blog. This week, I extract a list of all the M functions.


Power Query: Joining the dots

15 February 2023

Welcome to our Power Query blog. This week, I return to the topic of Table.Join().


Power Query: Web Grouping

8 February 2023

Welcome to our Power Query blog. This week, I investigate grouping queries in Excel for the Web.


Power Query: Refreshing Challenges on the Web – Part 2

1 February 2023

Welcome to our Power Query blog. This week, I continue investigating refreshing queries in Excel for the Web by looking at an example with a query and a PivotTable.


Power Query: Refreshing Challenges on the Web – Part 1

25 January 2023

Welcome to our Power Query blog. This week, I investigate how to refresh queries in Excel for the Web.


Power Query: Expendable Expand

18 January 2023

Welcome to our Power Query blog. This week, I investigate how to avoid expanding data after merging.


Power Query: Join or List - Part 7

11 January 2023

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table with approximate matching using List() functions.


Power Query: Join or List - Part 6

4 January 2023

Welcome to our Power Query blog. This week, I continue to continue comparing alternative approaches to extracting data from another table with approximate matching using List() functions.


Power Query: Join or List - Part 5

28 December 2022

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table with approximate matching using List() functions.


Newsletter