Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: It Takes All Types

22 March 2023

Welcome to our Power Query blog. This week, we extract data created by linked types.


Power Query: Power Query Tables Do Not Have to be Green

15 March 2023

Welcome to our Power Query blog. This week, we change the format of the Table loaded from Power Query.


Power Query: Handling Dynamic Arrays

8 March 2023

Welcome to our Power Query blog. This week, I extract data from a Dynamic Array.


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.


Newsletter