Row limit for Excel power query with setting "connection only"

Copper Contributor

Hi Excel Forum,

I know the limit of rows in Excel is 1048576. Therefore a Power query, that loads to a worksheet, needs to be under this limit.


Is it possible to exceed the row limit of 1048576 in a power query that is a "Connection only" (Query 1)


Then have a new query (Query 2) that has it's source set to (Query 1) but has filters to limit the number of rows


Only Query 2 would be loaded to an Excel worksheet

1 Reply


On practice it's limited only by computer resources. Performance could be quite low with such size. Think about query folding if it is applicable in your case.