Welcome to our Power Query blog. This week, I look at ways to improve the memory usage of a query involving flat files.

Welcome to our Power Query blog. This week, I look at some ways to make merges more efficient.

Welcome to our Power Query blog. This week, I look at solving a problem with a nested join and the M function Table.Buffer().

Welcome to our Power Query blog. This week, I look at a way to reorganise data in a table by merging with itself.

Welcome to our Power Query blog. This week, I look at a more efficient way of merging the data from last week, again when there is not a clear link between the tables

I have some sales contact data for my imaginary business. Unfortunately, I have some complaints and I want to allocate them to the correct salesperson.

Welcome to our Power Query blog. This week, I look at the Excel.Workbook() M function

Welcome to our Power Query blog. This week, I return to the running totals example from last week, to apply a more complex solution.

Welcome to our Power Query blog. This week, I revisit running totals.

Welcome to our Power Query blog. This week, I look at adding rows to existing data in order to present a complete picture.