Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation. Here is what you need to do.

Click Load to import it into Power BI, which will create a connection to the data and load it into Power BI. You can start adding visuals based on the imported Excel data.