The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
List.Contains has no limit.
1000 rows limit is for showing the preview in PQ not for List.Contains.
thanks
List.Contains has no limit.
1000 rows limit is for showing the preview in PQ not for List.Contains.