First Power BI report - Step-by-Step Guide

Introduction

This feature helps you create your very first report in Power BI. It guides you to load data, build visuals, and see your data story come alive on a page.

When you want to show sales numbers by product category on a simple page

When you need to create a report that shows monthly expenses with charts

When you want to explore your data visually for the first time

When you want to share a summary of your data with your team

When you want to practice building visuals using your own data

Steps

Step 1: Click

- Home tab > Get Data button

The Get Data window opens showing data source options

💡 Choose Excel or CSV if you have a file on your computer

Step 2: Select

- Your data source (e.g., Excel workbook) in the Get Data window

A preview of your data tables appears

💡 Pick the table or sheet that has the data you want to use

Step 3: Click

- Load button in the Get Data window

Your data loads into Power BI and appears in the Fields pane

Step 4: Drag

- A field (e.g., Sales Amount) from the Fields pane to the Report canvas

A visual (like a table or chart) appears showing that data

Step 5: Select

- Visualizations pane > Choose a visual type (e.g., Bar chart)

The visual changes to the selected chart type on the canvas

Step 6: Drag

- Other fields (e.g., Product Category) to the Axis or Legend area in Visualizations pane

The chart updates to group data by that field

Step 7: Click

- File tab > Save As

Your report is saved as a Power BI file on your computer

Before vs After

Before

Power BI Desktop opens with a blank report page and no data loaded

After

Report page shows a bar chart with sales amounts grouped by product category

Settings Reference

Data source selection

📍 Get Data window

Choose where to get your data from

Default: None selected

Visual type

📍 Visualizations pane

Select how your data is shown visually

Default: Table

Fields placement

📍 Visualizations pane fields wells (Axis, Legend, Values)

Define how data fields affect the visual

Default: Empty

Common Mistakes

Not loading data before trying to create visuals

Without data loaded, visuals cannot display anything

Always load your data first using Get Data, then build visuals

Dragging fields to the report canvas instead of the Visualizations pane

Dragging to the canvas creates a default visual but may not group data as expected

Drag fields to the correct areas in the Visualizations pane to control the visual

Summary

You learned how to load data into Power BI and create your first report page.

You can choose different visual types and place fields to shape your data story.

Remember to always load your data first before building visuals.