Importing an Excel file into Power BI is super easy. Here’s how to do it:
- Open Power BI Desktop, click 'Black report'.
- Select 'Import data from Excel' as your data source.
- Browse and select your .xlsx file. Once done, click 'Open'.
- Power BI will show the list of tables/sheets in the file. Check the boxes for the ones you want to import.
- Click 'Load'
- After loading, your Excel data is now part of your Power BI model and ready for visualizations.