Forum Discussion
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...
Cat appears in the word applications.
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
Hi,
Do not paste the data into a Table. Instead, import data from the Excel file.