Forum Discussion

Jun_Wang's avatar
Jun_Wang
Advocate I
4 years ago

optimise power query codes

Hi there,   It'd highly appreciated if some one can help optimise power query codes.   I have a very big table with more than 500 columns along with nested tables. I used to use table.selectRows ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Jun_Wang 

 

I recommend that you separate Table.SelectColumns and Table.SelectRows into two separate steps. This may improve the performance than combining them in a single step. 

 

It is possible to filter a nested table without expanding it. I will provide a sample later but I'm not sure whether it will improve the performance. 

 

Best Regards,
Community Support Team _ Jing