How to Get Sample Data for Power BI

Learning Power BI opens up a world of data visualization, but you can't build dashboards without data. Finding the right sample datasets to practice with is the first step, and thankfully, you don't have to look far. This tutorial will show you several easy ways to get free, high-quality sample data you can start using in Power BI today.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Practice with Sample Data?

Before jumping into the methods, it’s helpful to understand why using sample data is so important. Reading about Power BI features is one thing, but real learning happens when you get your hands dirty. Sample data allows you to:

• Build Muscle Memory: The more you practice importing data, creating relationships, and building visuals, the faster and more intuitive the process becomes.
• Experiment Safely: Want to try a complex DAX formula or a new type of visual? A sample dataset is your playground. Making mistakes here is part of the learning process, with zero risk to actual business data.
• Create Portfolio Projects: A public dashboard built with an interesting dataset can be a powerful way to showcase your skills to potential employers or clients.

Method 1: Use Power BI's Built-in Sample Data

The easiest way to get started is by using the sample dataset that comes packaged with Power BI Desktop. It’s perfect for your first few hours with the tool. Microsoft has included a simple financial dataset that's ready to go in just a few clicks.

Step-by-Step Instructions:

1. Open Power BI Desktop. If it's your first time, you'll see a welcome screen. Close it to reveal the main canvas.
2. On the blank report canvas, you will see a section called "Add data to your report." Click on the link that says "Try a sample dataset."
3. A dialog box will pop up, giving you two options. To import the raw data, click the button that says "Load sample data." This will let you build a report from scratch, which is exactly what we want for practice.
4. The "Navigator" window will appear, showing you the tables available in the sample Excel file. The file is called "Financial Sample.xlsx".
5. Check the box next to the "financials" table. You'll see a preview of the data on the right, which includes columns for sales, cost of goods sold, product categories, countries, and dates.
6. Now you have a choice: “Load” or “Transform Data”.

• Load: This option brings the data directly into your Power BI data model as-is. Since this sample data is already clean, this is a perfectly good option.
• Transform Data: This opens the Power Query Editor, where you can clean, shape, and restructure your data. It's a fundamental part of Power BI, so it’s great to get familiar with it. For now, you can just click Load.

That's it! The data is now loaded into your Power BI file. You can see all the columns (or "fields") listed in the Data pane on the right-hand side, ready for you to start dragging and dropping them onto the canvas to create your first visuals.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: Download Official Microsoft Sample Packs

The single built-in financial sample is great, but Microsoft provides a much wider variety of more complex datasets online for free. These packs often include not just the raw data (like Excel files or .csv files) but also fully completed Power BI reports (.pbix files). Studying these completed reports is an amazing way to learn advanced techniques by seeing how the pros build their data models and write DAX measures.

These samples cover common business scenarios and are much richer than the basic financial file.

Where to Find Them:

You can find the full list on the official Microsoft Power BI documentation site. Simply search for "Power BI samples" or go directly to the page. Some of the most popular sample packs include:

• Customer Profitability Sample: Analyze KPIs for executives, products, and customers. It has data broken down by industry, location, and executive.
• Human Resources Sample: Analyze new hires, active employees, and employees who have left. You can explore trends in hiring and identify reasons for attrition.
• Sales and Marketing Sample: Analyze market share, sentiment, and sales performance for a manufacturing company. Perfect for practicing marketing analytics.
• Retail Analysis Sample: Focuses on sales data from multiple stores and districts, great for analyzing item performance and district-level trends.
• Supplier Quality Sample: Analyze defect rates and TDD (Total Defect Downtime) to uncover which suppliers and plants are performing best.

These usually download as a zip file containing the report, dataset, or both. You can either import the data into a blank report yourself or open the .pbix file directly to explore the finished product.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 3: Explore Public and Open Datasets

Once you’re comfortable with the basics, using real-world data can make your learning much more engaging. There are thousands of free datasets on the web from governments, academic institutions, and public communities. These are often much larger and messier than curated samples, which gives you valuable practice in data cleaning and transformation using the Power Query Editor.

Top Places to Find Public Data:

• Kaggle: This is the go-to site for data scientists and analysts. It hosts a massive library of datasets on everything from video game sales and Netflix movie ratings to airline passenger numbers and climate data. The data is usually a bit cleaner than other public sources and often comes with context and examples of what others have done with it.
• Data.gov: This is the home of the U.S. government's open data. You can find datasets from agencies like the Census Bureau, the FBI, and the Department of Agriculture on topics like crime statistics, population trends, and economic indicators.
• Google Dataset Search: This tool functions like a regular search engine but exclusively for datasets. If you have a specific topic in mind, like "NYC taxi trips" or "global EV sales," this is a great place to start your search.
• Awesome Public Datasets on GitHub: Many developers and analysts curate lists of free, high-quality public datasets on GitHub. A quick search for "awesome public datasets" will give you a list of hundreds of links categorized by topic (like finance, sports, or nature).

To use these, you'll typically download a .csv or Excel file and import it into Power BI using the "Get Data" option on the home ribbon.

Method 4: Create Your Own Sample Data from Scratch

Sometimes you have a very specific scenario in mind and can't find the perfect dataset. In these cases, it's often easiest to just create your own. This also forces you to think clearly about data structure, which is a key skill for any analyst.

Use Excel or Google Sheets

The simplest way to create your own file is with a spreadsheet tool.

1. Open a new spreadsheet in Excel or Google Sheets.
2. Define your columns first. Think about what you want to measure. For example, to create a simple sales report, you might make columns for:

• OrderID
• OrderDate
• Salesperson
• Region (e.g., North, South, East, West)
• Product (e.g., Product A, Product B, Product C)
• Quantity
• UnitPrice
• TotalSale

1. Start populating the data. For numeric fields like Quantity or UnitPrice, you can use the RANDBETWEEN function to generate random values quickly. For example, in Excel, you could type:

=RANDBETWEEN(1, 100)

...and drag the formula down to create hundreds of random numbers from 1 to 100.

1. Once you have a few hundred rows, save the file as a .xlsx or .csv and import it into Power BI. You’ve now got a perfectly customized dataset built for your specific practice needs.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Use an Online Data Generator

If you need a lot of data quickly, an online tool can be even faster. Websites like Mockaroo or GenerateData.com allow you to design a schema and then generate thousands or even millions of rows of realistic-looking fake data. You can define fields for names, emails, countries, addresses, currencies, and much more. Once generated, you can download the data as a CSV and pull it into Power BI.

Final Thoughts

Getting your hands on quality sample data is the first and most critical step in teaching yourself Power BI. Whether you start with the simple built-in financial file, download official Microsoft sample packs, explore massive real-world datasets from Kaggle, or create your own, the key is to be proactive and dive in. The more you work with different types of data, the more prepared you'll be to tackle any real-world analysis task.

Of course, once you've learned the ropes in a tool like Power BI, you'll find that much of your time is still spent on the tedious work of connecting sources, cleaning data, and keeping dashboards up-to-date. This is where we designed Graphed to simplify the entire process. Rather than spending hours building reports and struggling with platform-specific tools, we enable you to instantly connect data sources and build live dashboards just by using natural language. It helps free you from the manual busywork, so you can spend less time pulling data and more time acting on it.