How to Use Power BI Desktop for Free

Microsoft Power BI Desktop is a surprisingly powerful and completely free tool that you can download right now to start turning raw data into clear, interactive visuals. This article walks you through exactly what you can do with the free version, how to get started, and how to build your first simple report today.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What You Can Do with the Free Power BI Desktop

Many people assume a "free" version of a business intelligence tool must be heavily restricted, but Power BI Desktop offers an incredible amount of functionality. It's the primary application where all Power BI reports are created, regardless of whether you have a paid license or not.

Here’s what you can do with it at no cost:

• Connect to hundreds of data sources: Pull data from local files like Excel workbooks, CSVs, and PDFs, or connect directly to online services and databases like Salesforce, SQL Server, and an array of web sources.
• Transform and clean your data: Use the built-in Power Query Editor to clean, shape, merge, and organize your data before you start building. This is arguably one of the most powerful features, allowing you to create a solid foundation for your reports.
• Build complex data models: If you're working with multiple tables, you can create relationships between them, just like you would in a more advanced database tool. You can also create powerful calculations and custom metrics using Data Analysis Expressions (DAX).
• Create interactive reports: You get access to the full library of visuals - bar charts, line graphs, maps, cards, tables, and slicers. These visuals are interactive by default, allowing you to click on elements to cross-filter and drill down into your data on the fly.
• Save and export locally: You can save your complete report as a Power BI file (.PBIX) on your computer or export your report pages as a static PDF or PowerPoint file to share snapshots of your work.

So, What’s the Catch?

The main limitation of the free license is centered around sharing and collaboration. Without a paid Power BI Pro or Premium license, you cannot:

• Publish and share your interactive reports to the Power BI web service.
• Create shareable links or embed reports on websites.
• Collaborate with colleagues in shared App Workspaces.
• Subscribe yourself or others to automated report emails.

In short, Power BI Desktop is your free personal data analysis and report creation tool. To share and collaborate online, you need to step up to a paid plan. But for learning BI, analyzing your own data, and creating reports for local use, the free version is more than enough.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Getting Started: Downloading and Installing Power BI Desktop

Getting your hands on the tool is straightforward. You have two primary options for downloading it.

1. Download from the Microsoft Store (Recommended)

If you're using Windows 10 or 11, the easiest method is to get it from the Microsoft Store.

• Open the Microsoft Store on your PC.
• Search for "Power BI Desktop."
• Click "Get" or "Install."

The main benefit of this approach is that Power BI is updated monthly with new features, and the store version handles these updates for you automatically in the background. No manual downloads needed.

2. Download Directly from the Website

You can also download the installer directly from the official Microsoft Power BI website.

• Navigate to the Power BI Downloads page.
• Click "Download" for Power BI Desktop. You may be redirected or see an option to open the Microsoft Store - if so, you can close that and look for the "Advanced download options" link instead.
• On the download page, select your language and choose the appropriate file (x64 for most modern computers).
• Run the installer and follow the on-screen instructions.

Your First Report: A Step-by-Step Walkthrough

Let's build a simple report to demonstrate how easy it is to get started. For this example, we’ll use a basic sales spreadsheet.

Step 1: Get Your Data

Once you have Power BI Desktop open, you’ll see a canvas for building your report. The first thing we need is data.

In the "Home" tab of the ribbon, click Get Data. A window will pop up with a huge list of potential data sources. For our example, select Excel workbook or Text/CSV, depending on your file type, and click "Connect."

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Clean Up Your Data with Power Query

After you select your file, a "Navigator" window appears, showing you the sheets or tables within it. Check the box next to the table you want to use. You'll see a preview of your data.

Before loading it, it’s a good practice to click Transform Data. This opens the Power Query Editor, a powerful tool for cleaning data. Here you can:

• Remove unwanted columns.
• Rename columns for clarity.
• Check column data types (e.g., make sure numbers are formatted as numbers and dates are formatted as dates).

Once you're happy that your data looks clean, click Close & Apply in the top-left corner.

Step 3: Understand the Interface

Power BI will now load your data. We're now in the "Report" view. Before building, take a quick look around:

• On the right, the Fields pane lists all the columns from your data table.
• The Visualizations pane contains all the chart types you can create.
• The main white space is your report canvas, where you'll arrange your visuals.

Step 4: Build Your First Visualization

Let's create a bar chart showing sales by product category.

• In the Visualizations pane, click on the icon for a Stacked column chart.
• An empty visual will appear on your canvas. With it selected, go to your Fields pane.
• Click and drag your "Category" field to the "X-axis" well in the Visualizations pane.
• Click and drag your "Sales Amount" field to the "Y-axis" well.

Instantly, you should see a column chart visualizing your sales data. That's it! To make it even better, drag the corner of the chart to resize it and move it around the canvas.

Step 5: Add a Second, Interactive Visual

Now let's add a "Slicer," which is an interactive filter.

• Click on an empty spot on the canvas to de-select your column chart.
• In the Visualizations pane, click the Slicer icon.
• An empty slicer will appear. With it selected, drag your "Region" field from the Fields pane into the "Field" well.

You now have a list of all your regions. Try checking the box for one of the regions. Notice how your column chart instantly updates to show sales data for only that selected region. This dynamic filtering is the core of what makes Power BI so powerful.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Saving and Sharing Your Work (The Free Way)

Even without a paid plan, you have a few options to get your report in front of others.

• Save as a .PBIX File: This is the editable Power BI project file. You can save it and email it to anyone, but the recipient must also have Power BI Desktop installed for free to open and view the report.
• Export to PDF: Go to File → Export → Export to PDF. This will create a high-quality, non-interactive document of your report pages. It's a great option for printing or emailing a static snapshot.
• Export to PowerPoint: You can also export the report to a PowerPoint presentation, which will create a slide for each report page with a static image of the visuals.

When Should You Consider an Upgrade?

You’ll know it’s time to upgrade from the free version when you find yourself needing to share interactive reports and collaborate with a team. You should upgrade to a paid license if you need to:

• Publish interactive reports that your team can access via a web browser.
• Create a central dashboard that multiple users can view and use.
• Manage user permissions and security to control who sees what data.
• Schedule automatic data refreshes to keep your reports constantly up-to-date online.

Final Thoughts

Power BI Desktop is an incredibly generous and full-featured platform available at no cost. It’s the perfect way for individuals, students, or business professionals to learn business intelligence, analyze data sets, and create powerful local reports. It allows you to transform raw data from spreadsheets and other sources into actionable insights without spending a dime.

While tools like Power BI are fantastic, the learning curve to master things like DAX and Power Query can still be a significant investment of time. For marketing and sales teams who need answers quickly, that friction matters. We built Graphed to solve exactly that problem. After connecting your data sources like Google Analytics, Shopify, and Salesforce in a few clicks, you can simply ask for the dashboards you need - "Show me my marketing spend vs. revenue by campaign" - and get them built in seconds. It’s like having an analyst on your team, giving you the real-time insights you need without the steep learning curve.