In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I’ll show you a different trick ...

The first thing to say is that if you don’t specify a join algorithm in the sixth parameter of Table.Join (it’s an optional parameter), Power Query will try to decide which algorithm to use based on ...

How to combine data ranges with Microsoft Power Query in Excel Your email has been sent Microsoft Power Query showed up in Excel 2016, though earlier versions can ...

There are times that you you want to use the Table.Skip Power Query function, but the number of rows you want to skip varies from file to file in your folder. You want the number of rows to be dynamic ...

Learn how Excel functions can act as data using LAMBDA, LET, and BYROW, so you reuse logic and cut formula edits.

Microsoft Power Query requires less specialized knowledge when trying to find duplicate records in a Microsoft Excel sheet. There are several ways to find duplicates in a Microsoft Excel sheet. You ...

Excel-Integrator (EI) is a semi-automated procedure to include periodically updated CSV data into an Excel workbook table that serves as a source for other analysis such as pivot tables or structured ...