Query Steps Order

[JackR19]

Does anyone have any advice on the best method of ordering query steps to reduce loading time? For example leaving remove duplicates until the last step. Should removing/filtering columns come first?

Any help is appreciated

[v-chuncz-msft · Accepted solution]

@JackR19 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Query-Folding-Documentation/m-p/359796#M162306

[Greg_Deckler]

In theory, doing your removing/filtering should come first since that reduces the amount of rows/columns that subsequent steps need to process. In theory...