Forum Discussion
Fuzzy Matching list size limit?
1. two different lists. keywords list is less than 67 rows.2. pbi matches words @ .5 threshold3. added 4 new words to list4. fails to match ANY words after refreshHello, i am fuzzy matching in pbi, pulling a list of keywords from excel, then comparing that list of keywords to another excel list of long strings of text. it works fine when the list of keywords is small, but when i add more than ~67 keywords to the list, the entire matching fails to capture ANY matches. but as soon as i remove enough keywords to less than 67 it works fine again.
is anyone else getting a similar issue? ive even tried adding the keywords directly into pbi internal table and still it fails when i add more than 67 rows.
13 Replies
String text list left join to keywords list (to show all the strings, but only the keywords which are successfully found).
.50 threshold
ignoring case
not combining text parts
Hi,
In each row of the Test string column, can multiple keywords be found or will only one keyword be found in each row?
Hello, mulitple keywords can be found per row.
Hi,
Please share data in a format that can be pasted in an MS Excel file.
