Excel data import in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sample Excel sheet showing product names and their sales numbers.

Cell	Value
A1	Product
B1	Sales
A2	Apples
B2	100
A3	Bananas
B3	150
A4	Cherries
B4	200

Formula Trace

Import Excel data into Power BI

Step 1: Open Power BI Desktop and select 'Get Data' > 'Excel'

Step 2: Select the Excel file containing the sample data

Step 3: Choose the sheet with data (e.g., Sheet1)

Step 4: Click 'Load' to import data into Power BI

Cell Reference Map

   A        B  
1 Product  Sales
2 Apples   100 
3 Bananas  150 
4 Cherries 200 

The Excel sheet cells A1:B4 are referenced during import to create the data table.

Result

Power BI Fields Pane:
- Product
- Sales

Report View:
| Product | Sales |
|---------|-------|
| Apples  | 100   |
| Bananas | 150   |
| Cherries| 200   |

After import, Power BI shows the data fields and the table can be used in reports.

Sheet Trace Quiz - 3 Questions

What is the first step to import Excel data into Power BI?

A Select 'Get Data' and choose 'Excel'

B Create a new report

C Write a DAX formula

D Open Power Query Editor directly

Key Result

Excel data import in Power BI involves selecting 'Get Data' > 'Excel', choosing the sheet, previewing, then loading data.