Forum Discussion

jcbutts's avatar
jcbutts
Icon for Helper I rankHelper I
6 years ago

Filtering by a column in another table slows down peformance

Hi,   I am trying to filter a column of item ID's by those found in a column in another table.  I used the following M code to filter:   = Table.SelectRows(#"Renamed Columns2", each List.Contains...
Need Help
kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

Have you tried doing the filtering in the source, before loading the table?

  • jcbutts's avatar
    jcbutts
    Icon for Helper I rankHelper I
    6 years ago

    I don't want to filter the source itself, as it may be a fluid task that I don't want to constantly keep updating.  At first, I was hopeful that I could simply filter via the visualizations in the desktop, but nothing worked.  Filtering in the query editor gets me the right visuals, it just takes a long time to load.