Welcome to our Power Query blog. This week, I look at combining sheets where the columns do not match.

Welcome to our Power Query blog. This week, I look at a problem I came across when uploading a large dataset from Excel.

Welcome to our Power Query blog. This week, I look at how Power BI Desktop uses query folding in the Power Query engine.

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

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

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

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.

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

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

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.