Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Folding Table

19 May 2021

Welcome to our Power Query blog. This week, I look at Query Folding.


Power Query: Find a Table

12 May 2021

Welcome to our Power Query blog. This week, I look at what to do when the location of a table is changed.


Power Query: Group Text

5 May 2021

Welcome to our Power Query blog. This week, I look at how to modify a grouping statement to accommodate text fields.


Power Query: Arranging a List

28 April 2021

Welcome to our Power Query blog. This week, I look at how to translate a range of data contained in one cell to a list of cells.


Power Query: Dating Options

21 April 2021

Welcome to our Power Query blog. This week I look at how to deal with dates in a variety of formats.


Power Query: Key Facts

14 April 2021

Welcome to our Power Query blog. This week, I look at some shortcuts to use in Power BI Transform Data.


Power Query: Flat with a View

7 April 2021

Welcome to our Power Query blog. This week, I look at how to improve the memory used when loading my flat file query to Power BI Desktop.


Power Query: Flat Out

31 March 2021

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


Power Query: More Merging Matters

24 March 2021

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


Power Query: Merging Matters

17 March 2021

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


Newsletter