I'm curious, which ones of these limits are you hitting? https://support.microsoft.com/en-gb/office/power-query-specifications-and-limits-in-excel-5fb2807c-1b16

I'm curious, which ones of these limits are you hitting? https://support.microsoft.com/en-gb/office/power-query-specifications-and-limits-in-excel-5fb2807c-1b16-4257-aa5b-6793f051a9f4 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.