Forum Discussion
Solved
Excel VLOOKUP against Power BI entity
Hello everyone, I have a Power BI custom table containing all comprehensive information and it consists of 1.4mln rows. I would like to somehow link this Power BI table to an excel spreadsheet an...
You can make an Excel table into which you paste your 10 search items, let's say 10 Account Numbers. Use get data from table or range to add this table to power query, and then make it a list. Use that list in a Table.SelectRows(PriorStepOrTableName, each List.Contains(List.Buffer(NameOfYourUpdatedList), [Account Number]))
Assuming that you'll be loading the resulting table to an Excel sheet, you can just update your list in Excel, then just click Refresh all.
--Nate
You can use the Merge feature in Power Query also