I have an Excel Workbook where I am performing data transformations in Power Query, but loading the data back to the workbook takes an incredibly long time. When I am in power query editor, the data loads relatively fast for each of my queries, but once I try refreshing my data into the Excel Workbook it takes a very long time. I've tried turning off "load data preview in background" Table.buffers, etc to try and speed it up but have not had significant improvements in speed. Any additional ideas would be greatly appreciated.

Good day bingsu , Imke Feldmann has an article on Power Query performance improvement techniques here - it includes the things you have tried plus others. Quite a straightfoward way of improving performance is described in this video by Paul Turley - reduce the number of steps by gathering like operations into a single step (e.g. avoid multiple re-typing steps and re-type at the end if possible). Hope these give you some ideas.

How can I speed up PQ loading data in Excel | Microsoft Fabric Community

Forum Discussion

Related content

Improve report/dashboard performance and loading speed

Tips on speeding up Table.NestedJoin

Fast Load "export" to Excel

Microsoft Exchange - improve loading speed

Increase the loading speed of a table visualization