Forum Discussion
cparrot
Helper I
Helper IFuzzy 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...
cparrotHelper I
Helper IHi 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
Super User
Super UserHi,
Do not paste the data into a Table. Instead, import data from the Excel file.