How to Start Power BI Desktop

Jumping into Power BI Desktop for the first time might feel a bit intimidating, but it's one of the most powerful free tools you can learn for telling stories with your data. This guide will walk you through everything you need to know to get started, from downloading the software to creating your very first interactive report. We'll cover installing the app, connecting to data, and building your first charts step-by-step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is Power BI Desktop?

Power BI Desktop is a free application you install on your local computer that lets you connect to various data sources, clean and transform that data, and then build visuals and reports. Think of it as your personal workshop for data analysis. You gather your raw materials (data), shape them into something usable, and then assemble them into a finished product (a report or dashboard).

It's the primary tool for report designers and analysts. The general workflow is:

• Connect: Pull in data from hundreds of sources, like Excel spreadsheets, databases (SQL), or web services.
• Transform: Clean up the data using the built-in Power Query Editor. This might include removing unnecessary columns, changing data types, or fixing errors.
• Visualize: Build interactive charts, graphs, maps, and tables on the report canvas.

Once you’ve built a report in Power BI Desktop, you can then publish it to the Power BI Service, a cloud-based service where you can share your reports with colleagues and create dashboards. For now, though, our entire focus will be on the desktop application where the creation happens.

Getting Power BI Desktop Installed

Before you get started, it's important to note that Power BI Desktop is a Windows-only application. If you're on a Mac, you'll need to use a solution like Parallels or Boot Camp to run Windows first.

Microsoft offers two main ways to install the application. Let's cover the recommended method first.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Installing from the Microsoft Store (Recommended)

This is the easiest and most effective way to install and manage Power BI Desktop. The huge advantage is that the app will update automatically in the background, ensuring you always have the latest features and bug fixes without any manual effort.

1. Navigate to the Microsoft Store on your Windows PC (you can find it in your Start menu).
2. In the search bar, type "Power BI Desktop."
3. Click the "Get" button. The download and installation will start automatically.

That's it. Once installed, you can launch it from your Start menu like any other application.

Installing Directly from the Web

If you have IT restrictions or prefer a manual installation, you can download the installer directly from Microsoft's website.

1. Go to the official Power BI Desktop download page.
2. Click "Download." You will be prompted to choose between a 32-bit (x86) and a 64-bit (x64) version. Most modern computers are 64-bit, so choose that unless you have a specific reason not to.
3. Once the .exe file has downloaded, open it. Follow the on-screen instructions from the installation wizard. You'll simply click "Next" a few times, accept the terms, and choose your install location.

With this method, you will need to manually download and install new versions each month to stay current.

A Quick Tour of the Power BI Interface

When you first open Power BI Desktop, you'll be greeted by a splash screen. You can close this to enter the main workspace. It can seem overwhelming initially, so let’s break down the main components you'll be using.

1. The Three Core Panes

Over on the right-hand side, you'll see three essential panes that you'll use constantly:

• Fields Pane: Once you've loaded data, this pane will list all of your data tables and the columns (also called fields) within them. This is where you'll drag and drop items from to build your visuals.
• Visualizations Pane: This is where you choose the type of visual you want to create (bar chart, line chart, map, etc.) and configure it. You'll drag fields from the Fields pane into the wells here, such as the X-axis, Y-axis, and Legend.
• Filters Pane: This pane allows you to add filters to your visuals, a specific page, or your entire report. For example, you could filter a report to show data for only the last year or a specific product category.

2. The Report Canvas

This is the big, blank area in the middle. It's your canvas where you will arrange and design your visuals to create your report pages. You can add, resize, and position your charts and tables here.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. The Main Views

On the left-hand side, you'll see three little icons that let you switch between the three main views of Power BI Desktop:

• Report View: The default view. This is where you build your report on the canvas.
• Data View: This view gives you a spreadsheet-like look at your actual data tables. You can inspect the raw data, create basic filters, and review the information you’ve loaded.
• Model View: In this view, you can see all of your data tables and how they're related to each other. If you're pulling data from multiple files (e.g., a Sales table and a Product information table), this is where you create relationships to connect them.

4. The Ribbon

Just like in other Microsoft products like Excel or Word, the ribbon sits at the top and organizes commands into tabs like Home, Insert, Modeling, and View. Your most common starting point will be the "Get Data" button on the Home tab.

Building Your First Report: A Step-by-Step Guide

The best way to learn is by doing. Let's walk through creating a simple sales report from start to finish. We'll use a sample Excel file. You can easily create a similar file to follow along. Just make a spreadsheet with columns like Date, Sales Region, Product, Units Sold, and Revenue.

Step 1: Get Data

First, we need to bring some data into Power BI.

1. On the Home tab of the ribbon, click the Get Data button.
2. A menu with common data sources will appear. Since our sample data is in an Excel file, select Excel workbook. If you don't see it on the list, you can click "More..." to open a new window with hundreds of available connectors.
3. An "Open" dialog box will appear. Navigate to your sample Excel file and then click Open.
4. A Navigator window will pop up to show any worksheets or tables found in your file. Check the box next to the spreadsheet that contains the data, and a preview will appear on the right.
5. At the bottom of the Navigator, you’ll see two buttons: Load and Transform Data.

Step 2: Transform Your Data

After launching "Transform Data," you’ll be taken to the Power Query Editor. This is where all the data cleaning and transformation magic happens.

• Remove Columns: You can remove unwanted columns by right-clicking and selecting Remove Columns.
• Change Data Types: Ensure each column is set to the correct data type by right-clicking and selecting Change Type.

1. Make sure to perform necessary transformations to prepare your data correctly.
2. Once ready, click the Close & Apply button to apply the changes and load the data into Power BI.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Visualize Your Data

This is where the fun begins! Start creating visuals on your report page.

1. Create a Bar Chart of Revenue by Region

1. Go to the Visualizations pane and click the Stacked column chart icon. A blank visual placeholder will appear on your canvas.
2. With the visual selected, turn your attention to the Fields pane. Find your Sales Region field and drag it into the X-axis well in the Visualizations pane.
3. Next, find your Revenue field and drag it into the Y-axis well.

Instantly, Power BI will generate a column chart showing your total revenue broken down by each sales region. Easy, right?

2. Create a Pie Chart and a Card Visual

Let's add a couple more visuals to round out our report.

• Pie Chart: Click on a blank space on your canvas. From the Visualizations pane, select the Pie chart icon. Drag your Product field to the Legend well and your Units Sold field to the Values well. Now you have a clean visual showing which products make up the bulk of your sales volume.
• Card Visual: Click on another blank area. Select the Card icon from the Visualizations pane. Drag your Revenue field into the Fields well. This will create a simple, large number showing your total revenue across all regions and products.

Notice how everything is interactive. If you click on a region in your column chart, the pie chart and card will automatically filter to show data for only that selection. This interactivity is one of Power BI's most powerful features.

Saving Your Work

You've built your first report! To save it, simply go to File > Save and choose a location on your computer. Your file will be saved with a .pbix extension. This single file contains your data, the transformation steps you performed, and all the visuals you designed. You can now close it and reopen it later to continue working.

Final Thoughts

You now know the full process to get started with Power BI Desktop, from installation to creating an interactive multi-visual report. By connecting to data, cleaning it up in the Power Query Editor, and then visualizing it on the canvas, you've taken the first major step into business intelligence.

For many teams, the setup time and learning curve for tools like Power BI can still feel like a hurdle. We built Graphed to remove that friction completely. Instead of manually clicking, dragging, and dropping fields, you can just ask questions in plain English like, "show me a bar chart of our total revenue by sales region," and watch as the dashboards are built for you. We connect to your data sources in real-time, letting you skip the manual refresh cycle and get straight to the insights.