Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

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.


Power Query: Join or List - Part 4

21 December 2022

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table, this time with approximate matching.


Power Query: Join or List – Part 3

14 December 2022

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table, this time, with approximate matching.


Power Query: Join or List – Part 2

7 December 2022

Welcome to our Power Query blog. This week, I continue comparing alternative approaches to extracting data from another table.


Newsletter