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!

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Likely having to do some kind of table scanning. ImkeF ?