Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

List.Contains() is slow

Hi,   I am using = Table.SelectRows(Table1, each List.Contains(List, [UID])) to filter out 300 categories from a table that has 1.6mil rows. However, it is loading very slow when I apply the query ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    Are you using a direct query mode?Why not filter the table in table view?

     

    Best Regards,
    Kelly
     
    Did I answer your question? Mark my post as a solution!

     

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ，

 

Are you using a direct query mode?Why not filter the table in table view?

 

Best Regards,
Kelly
 
Did I answer your question? Mark my post as a solution!

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-kelly-msft 

 

I am using import mode. I could do the filter in table view using LOOKUPVALUE. Is there a difference between the filter in table view vs query mode in terms of performance and speed?

 

Daren