Limit for List.Contains

[akhaliq7]

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?

[akhaliq7]

thanks

[Vijay_A_Verma · Accepted solution]

List.Contains has no limit.

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