Guides

Install Power BI Desktop and Build Your First Report

By Ravindra Bagale, Power BI & Data Analytics trainer · LinkedIn · Published: 30 September 2026 · Last updated: 30 September 2026

Install Power BI Desktop on Windows, open a blank report, load a small table, drop one visual, and save a .pbix — that is your first complete Power BI lap.

Download → Install → Get data → Load → Visual → Save .pbix

What do I need before this guide?

• A 64-bit Windows PC you control (or a Windows VM).
• Roughly 1–2 GB free disk for the app and a sample file.
• Optional map of the product family: Desktop vs Service vs Mobile.

Before and after (look at the tables first)

Install Desktop, then Get data. Before and after load, the numbers stay 190 — you just moved the table into the model.

Why install Desktop first (not only the Service)?

The Service is wonderful for sharing. But beginners who only click sample reports in the browser never practise the building skills.

Why you care:

1. Connecting your own Excel happens in Desktop.
2. Opening Transform data (Power Query) happens in Desktop.
3. Creating a measure (a formula that calculates for the filters on screen) happens in Desktop.
4. Saving a portable .pbix project happens in Desktop.

Desktop is the classroom bench. Install it once; every guide after this becomes concrete.

Tiny goal for tonight:

1. Mumbai sales 100, Pune sales 40.
2. One Card that shows 140.
3. One saved file you can reopen tomorrow.

Step 1 — Download from Microsoft

What this step is: getting the real app from Microsoft, not a random website.

Why you care: fake “powerbi-crack” downloads are malware theatre.

Vertical steps:

1. Open Microsoft’s official Power BI Desktop download page in your browser.
2. Choose the Microsoft Store button or the direct download / executable option listed there.
3. Prefer the official Microsoft page only.
4. If your company blocks the Store, use the exe path your IT allows.

Store vs exe (plain English)

1. Store — updates are easier; good for personal PCs.
2. Exe installer — common on locked-down office machines.
3. Both give you the same authoring app family — pick what your PC allows.

What you see on screen: a Microsoft download page with Install / Download buttons — not a random blog with “mirrored zip”.

Step 2 — Install and open

What this step is: putting Desktop on your Start menu and opening a blank report.

Why you care: if you cannot reach a blank canvas, later guides have nowhere to land.

Vertical steps:

1. Run the installer; accept the licence prompts.
2. Finish setup; launch Power BI Desktop.
3. You may see a splash with “Open report / Get data / Recent”.
4. Sign-in can wait if you only practise offline file sources today.
5. Aim for a blank report canvas in Report view.

Orient yourself for 60 seconds

1. Left edge: Report, Data, Model icons.
2. Top: the ribbon (Home, Insert, Modeling, …).
3. Centre: the canvas (where visuals sit).
4. Right: Visualizations, Build, Fields (names shift slightly by version — the idea stays).

If the panes vanished, use View on the ribbon to turn them back on. No panic.

What you see on screen: an empty white page waiting for a chart, plus Fields on the right (empty until you load data).

Step 3 — Get a tiny data table

You need some rows. Three beginner options. Pick Option A tonight if you want speed.

Option A — Enter data (fastest)

What it is: typing a tiny table inside Power BI without Excel.

Why you care: you can practise visuals even when you have no file ready.

Vertical steps:

1. Home → Enter data.
2. Type headers: City, Amount.
3. Add rows: Mumbai / 100, Pune / 40, Nashik / 80.
4. Name the table Sales at the bottom.
5. Click Load.

What you see on screen: a small grid editor, then after Load the Fields pane shows Sales with City and Amount.

Option B — CSV

1. Save a CSV from Notepad with the same three rows.
2. Home → Get data → Text/CSV.
3. Preview; Load (or Transform if types look odd).

Option C — Excel

1. Put the same table in Excel; optionally Format as Table.
2. Home → Get data → Excel workbook.
3. Tick the sheet or table in Navigator → Load.

Detailed Excel/CSV tips live in Connect Excel and CSV. Tonight, Option A is enough.

Step 4 — Load and glance at Data view

What this step is: checking the rows actually landed as numbers.

Why you care: charts go blank or sort wrongly when “100” is stored as text.

Vertical steps:

1. After Load, open Data view (table icon on the left).
2. Confirm columns and three rows: Mumbai 100, Pune 40, Nashik 80.
3. Check that Amount is a number, not text.
4. If Amount is text, fix types in Power Query (Transform data) before you chase visuals.

What you see on screen: a spreadsheet-like grid of your Sales table.

Step 5 — Build the first visual

What this step is: putting a number on the canvas so you can see the model working.

Why you care: a saved blank file teaches nothing. A Card showing 220 (100+40+80) proves the path.

Vertical steps:

1. Return to Report view.
2. Click a blank area of the canvas.
3. Select Card in Visualizations.
4. Tick Amount (or your numeric field) in Fields.
5. The card should show a total (220 for the sample).
6. Add a second visual: Clustered column chart.
7. Axis = City, Values = Amount.
8. Resize so both fit without overlapping titles.

Tiny “why” behind the clicks

1. A visual is empty until fields are assigned.
2. The model feeds every visual — you are not drawing in Paint.
3. Saving now freezes this lesson as a file you can reopen tomorrow.

What you see on screen:

1. A Card with 220.
2. Three columns: Mumbai tallest at 100, Nashik at 80, Pune at 40.

Step 6 — Save the .pbix

What this step is: writing your project to disk.

Why you care: without Save, the lesson evaporates when Desktop closes.

Vertical steps:

1. File → Save As.
2. Name it MyFirstReport.pbix in a folder you will find again (Documents/PowerBI is fine).
3. Close and reopen the file to prove it works.
4. Later: Home → Publish when you are ready for the Service.

What you see on screen: a normal Save dialog; the title bar shows your file name.

How do I fix common first-day errors?

What good looks like after day one

1. You can find Power BI Desktop in the Start menu without searching YouTube for “how to open”.
2. You know Report vs Data vs Model icons by sight.
3. You have one .pbix that opens with a Card showing a non-blank number (like 220).
4. You did not install a random third-party “theme pack exe” from a comment section.

Slow-motion: Enter data walkthrough

1. Home → Enter data.
2. Double-click Column1 header → type City.
3. Add column → Amount.
4. Rows: Mumbai 100, Pune 40, Nagpur 45, Nashik 70, Kolhapur 55.
5. Table name bottom-left: Sales.
6. Load.
7. Card on Amount → expect 310.
8. Column chart City vs Amount.
9. Save As day1-cities.pbix.

This five-city file becomes your sandbox for measures tomorrow.

Keyboard and mouse habits

1. Ctrl+S early and often.
2. Do not build fifteen pages on day one.
3. Rename page tabs: Overview, not Page 1.
4. If Desktop freezes on a huge Excel, start smaller — learning files should be tiny.