Forum Discussion
Solved
How can I speed up PQ loading data in Excel
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 ...
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.
Great! You found a solution!
Would you mind sharing it for all of us to learn from?
Thanks!