How Fast is Fast Data Load in Power Query?

Andrew Moss
Dec 11, 2021 · 9 min read
Cover Image — Fast Data Load in Power Query

In my previous article, Analysing 10 Million Rows in Excel, I showed you how to load a dataset into Power Query consisting of 10 million rows. In truth, it can handle a lot more than that, but I just wanted to dispel the myth that a million worksheet rows is all Excel is capable of.

This time, I am going to experiment to see how long it takes to load datasets of varying sizes. I will also…