Excel data import in Power BI - Step-by-Step Guide

Introduction

This feature helps you bring data from Excel files into Power BI. It solves the problem of starting your reports with data stored in Excel spreadsheets.

When you have sales data saved in Excel and want to create interactive charts in Power BI.

When your team shares monthly reports as Excel files and you need to analyze them together.

When you want to combine Excel data with other data sources in one Power BI report.

When you receive customer lists in Excel and want to visualize customer trends.

When you want to refresh your Power BI report automatically when the Excel file updates.

Steps

Step 1: Click

- Home tab on the Power BI Desktop ribbon

The Home tab options are shown

💡 The Home tab is the main place to start importing data

Step 2: Click

- Get data button in the Home tab

A list of data source options appears

Step 3: Select

- Excel from the data source list

A file browser window opens to select your Excel file

Step 4: Navigate and double-click

- Your Excel file in the file browser

Power BI opens the Navigator pane showing sheets and tables from the Excel file

Step 5: Check

- The box next to the sheet or table you want to import in the Navigator pane

The selected data preview appears on the right side

Step 6: Click

- Load button at the bottom of the Navigator pane

The Excel data loads into Power BI and appears in the Fields pane

Before vs After

Before

Power BI report has no data loaded; Fields pane is empty

After

Fields pane shows tables and columns from the imported Excel file

Settings Reference

Data load mode

📍 Navigator pane after selecting Excel data

Choose to load data directly or open Power Query Editor to clean or shape data before loading

Default: Load

File path

📍 File browser window when selecting Excel file

Select the Excel file location to import data from

Default: User selected

Common Mistakes

Selecting the wrong Excel sheet or table to import

You may load irrelevant data, causing confusion or errors in reports

Carefully preview data in the Navigator pane and select only the needed sheets or tables

Clicking Load without cleaning data when data needs shaping

Raw data may have errors or unwanted columns that affect report quality

Choose Transform Data to open Power Query Editor and clean data before loading

Summary

Excel data import lets you bring spreadsheet data into Power BI easily.

Use the Home tab > Get data > Excel to start the import process.

Always preview and select the correct sheet or table before loading.

Choose Transform Data if you need to clean or shape data before using it.