Quick summary
Linking Power BI to Excel lets you import spreadsheet data directly into Power BI Desktop as a structured dataset for analysis and visualization. This step-by-step process uses the built-in Import data from Excel connector to bring your tables and sheets into Power BI in just a few clicks.
Steps
- Open Power BI Desktop and click the Blank report option to start a new project.
- Select Import data from Excel as your data source from the available connector options.
- Browse to your Excel file, select it, and click Open to load it into the import dialog.
- Pick the sheets or tables you want to import by checking the boxes next to each one.
- Click Load to begin importing the selected Excel data into Power BI.
- Confirm that the Excel data has been successfully loaded into Power BI as a dataset, ready for reporting.
