Connecting PowerBI to a Microsoft Excel File

Excel spreadsheets are a very common way to store data. Connecting them is straightforward.

To connect an Excel sheet to Power BI, you must look at the file extension of the file you want to work with. For Microsoft Excel, xlxs or xls is the file extension to look out for.

Click Get Data and then select Excel Workbook as highlighted in the image below.

When you click the Excel workbook, it takes you to the file explorer to pick the files with Excel file extensions. Pick the file you want to work with and click Open.

The Navigator window will show you a list of sheets and tables within the Excel file. You can select a table to see a preview. Check the boxes for the tables you want to use, and then click Load.

The data from your Excel sheet will now be loaded into Power BI..