Find value and return row in excel spreadsheet with over 1 mil rows
the problem of excel being very slow in finding the value and it is
  very difficult to read information in the row


What is "slow" for you (in seconds) and how fast would you like the search to be?

In a lot of cases, the performance can be considerably improved by using INDEX and MATCH to search for values in Excel, instead of using VLOOKUP (which is known to be much slower in comparison).

Alternatively, you could install SQL Server Express on your machine, import the Excel file into a table, and use some SQL statements to find the values you want.

Power BI is a visualization tool, and doesn't seem appropriate for what you're describing which is preparing the data. You could use Power BI after, of course, to plot the final results.