Best Way to Filter Million Rows of Data

[Anonymous]

Hello,

One of our users is getting data from an Excel file (stored in network drive) and importing data from SAP HANA database. What he’s doing is filtering the SAP HANA queries based on the table from the excel file which he converted to ‘list’. He is using List.Contains() function to do the filter. The Excel file contains 2000+ rows and it is used to filter multiple SAP HANA queries with million rows.

Any suggestions on what other ways we could try to filter a list of million things down to 2000+? 

List.Contains() function seems not efficient and causes slow performance in Power Query.

Thank you!