Power Query performance question. Is it better to have 2 small tables merged or single large table?

[Akbarov]

Hello Dear community,

I am working with a workbook which is refreshing very frequently. (each few seconds)
I have data in columns B16:DE127
But I only need half of the data in Power Query. B16:AQ127 I only need column DE just for 1 criteria filtering.

I am curious, is it better if I get all B16:DE127 to Power Query or Just B16:AQ127 and separately adding DE16:DE127 and merge them for filtering.

Which option can make better performance?
Because I am guessing I will need some additional steps to merge.

Hope someone can give me some advice.

Best Regards.

 

[JEC]

Load it all, filter, then delete unnecessary columns. Merges will have negative impact on performance

 

[Akbarov]

Thank you for the reply. Probably you are right, but also in this case, I will need to add some additional steps to query.

 

[JEC]

That should not be a problem