How to Link Power BI to Excel

Guide

1. Open Power BI Desktop, click 'Black report'.

2. Select 'Import data from Excel' as your data source.

3. Browse to your Excel file and select it. Then, click 'Open'.

4. Pick the sheet(s) or tables you want to import. Check the boxes for the ones you want to import.

5. Click 'Load'.

6. The Excel data is loaded directly into Power BI as a dataset.