Forum Discussion

cparrot's avatar
cparrot
Icon for Helper I rankHelper I
4 years ago

Fuzzy Matching list size limit?

Hello, 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 li...
Need Help
Show and Tell
Tips and Tricks
cparrot's avatar
cparrot
Icon for Helper I rankHelper I
3 years ago

cat is flagged in two strings, but is actually only present in 1 of the strings.

tan is flagged, but does not appear in the string from which it is flagged.

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Cat appears in the word applications.

  • cparrot's avatar
    cparrot
    Icon for Helper I rankHelper I
    2 years ago

    Hi Ashish, thank you for your assist with this power bi. however, i am running into a 3000 row limit when copying and pasting into table1. i need to be able to pull from an external excel spreadsheet with 100,000+ rows of data. however, i get an error when using the steps you provided. what needs to be altered in the code so that both keywords and text can be pulled from excel spreadsheets?

     i changed the code to look for [Name] rather than [Text], but the result is empty

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    Do not paste the data into a Table.  Instead, import data from the Excel file.