Forum Discussion

akhaliq7's avatar
akhaliq7
Post Prodigy
4 years ago
Solved

Limit for List.Contains

I created a list from a column from my fact table I then used that list in a list.contains function on my dim table. I was sure there was a limit of 1000 rows before using list.contains and my list contains 1079 rows but List.contains still seems to work. Is the limit much higher? or is there no limit?

  • List.Contains has no limit.

    1000 rows limit is for showing the preview in PQ not for List.Contains.

2 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional

    List.Contains has no limit.

    1000 rows limit is for showing the preview in PQ not for List.Contains.