Quick summary
Importing an Excel file into Power BI lets you connect your .xlsx data directly to the Power BI model so you can build visualizations without manual data entry. This step-by-step walkthrough covers opening Power BI Desktop, selecting your Excel source, choosing the right sheets, and loading the data ready for reporting.
Steps
- Open Power BI Desktop and click Blank report to start a new project.
- Select Import data from Excel as your data source from the get-data options.
- Browse your file system, select your .xlsx file, and click Open to continue.
- Power BI displays the list of available tables and sheets inside the file — check the boxes next to the ones you want to import.
- Click Load to bring the selected sheets into Power BI.
- After loading, your Excel data is now part of your Power BI model and ready to use for visualizations.
