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

[Mike_Y_123]

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

[#2]

@Mike_Y_123 

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.