Forum Discussion
Row limit for Excel power query with setting "connection only"
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 ...
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.