I'm curious, which ones of these limits are you hitting? https://support.microsoft.com/en-gb/office/power-query-speci... If your answer is "Maximum number of rows filled to worksheet", you should understand that this means exactly what's written, rows filled to the worksheet - you can still have more rows in the source and do your transform/queries on that.