Very slow power query

[Melissa]

Hi @pedroccamara,

I would expect so. Start by reviewing these threads.

Is the order of applied steps important in power query

Hi Fredrik, That’s an excellent question. And you are right the order can matter greatly… I’ve found some articles by Chris Webb you’ll find interesting. His recommendations, start by removing all unnecessary columns from your tables, especially if you’re doing transformations such as sorts, merges, groupings, pivots or unpivots. And most optimisations the Power Query engine can use only happen on tables – not records or lists – so you should always try to work with tables whenever you can. F…

Query Diagnostics

Not really looked into this much yet, but thought I would start a post on this subject anyway. A new feature that allows you to determine what Power Query is doing behind the scenes. Find slowdowns and background events etc. Microsoft will be expanding on this feature in the future.

Speed/Performance aspects –