Forum Discussion

bingsu's avatar
bingsu
New Member
2 years ago
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 ...
Need Help
  • collinsg's avatar
    collinsg
    2 years ago

    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.

collinsg's avatar
collinsg
Solution Sage
2 years ago

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.