How to Add Data in Power BI

97% of Fortune 500 companies use Microsoft Power BI. Yet most people waste hours trying to figure out why their data isn’t connecting. This guide changes that.

Power BI is one of the most powerful business intelligence tools on the planet. But here’s the thing — it’s only as good as the data you feed it. Whether you’re pulling numbers from an Excel sheet, a live SQL database, a web page, or entering data manually, the process needs to be fast, clean, and reliable.

This step-by-step guide covers every major method to add data in Power BI — no technical degree required.

Why Getting Your Data Right in Power BI Matters

Before we jump into the how, let’s talk about the why.

According to McKinsey, data-driven organizations are 23x more likely to acquire customers and 6x more likely to retain them. Companies using business intelligence tools like Power BI report up to 80% faster report creation compared to manual methods.

But none of that happens if you can’t get your data into the tool correctly.

Gartner reports that poor data quality costs organizations an average of $12.9 million every year. The first step to clean insights is a clean, properly connected data source — and that starts right here.

What Is “Get Data” in Power BI?

“Get Data” is Power BI’s universal entry point for connecting to any data source. You’ll find it in the Home tab of Power BI Desktop.

From there, you can connect to 100+ data sources — from simple spreadsheets to complex cloud databases. Every method below starts from this same place.

To open Get Data:

• Open Power BI Desktop
• Click Home in the top ribbon
• Click Get Data
• Choose your data source from the list

That’s the gateway. Now let’s explore what’s behind it.

How to Add Data from Excel in Power BI

Excel is the most common starting point for Power BI users worldwide. According to Microsoft, over 750 million people use Excel globally — and a large majority of Power BI reports start with an Excel file.

Steps to import Excel data:

• Open Power BI Desktop and click Get Data
• Select Excel Workbook from the list
• Browse to your file and click Open
• In the Navigator panel, select the sheet or table you want
• Click Load to import directly, or Transform Data to clean it first in Power Query

Pro tip: If your Excel file has named tables (formatted as Excel Tables), Power BI will detect them automatically. This makes the connection cleaner and more reliable when the file updates.

How to Add Data from a CSV or Text File

CSV files are lightweight, universal, and one of the fastest ways to get data into Power BI. If you’re exporting reports from a CRM, marketing platform, or analytics tool, chances are it’s coming out as a CSV.

Steps:

• Click Get Data → Text/CSV
• Browse to your .csv or .txt file and click Open
• Power BI previews the data automatically
• Adjust delimiter settings if needed (comma, semicolon, tab, etc.)
• Click Load or Transform Data

Watch for this: Power BI sometimes misdetects column data types — especially dates formatted as text. Go into Transform Data (Power Query) and manually set the correct data type for each column before loading.

How to Add Data from a SQL Database

SQL databases are the backbone of serious business reporting. According to Stack Overflow’s Developer Survey, SQL is among the most widely used languages in the world, with over 54% of professional developers working with it regularly.

Power BI connects natively to SQL Server, MySQL, PostgreSQL, Azure SQL, and more.

Steps for SQL Server:

• Click Get Data → SQL Server
• Enter your Server name and Database name
• Choose Import (pulls data into Power BI) or DirectQuery (queries the database live)
• Enter your credentials if prompted
• Select the tables or views you want in the Navigator
• Click Load or Transform Data

Import vs. DirectQuery:

• Import is faster for reports and works offline — best for most use cases
• DirectQuery is better when you need real-time data or when datasets are too large to import

How to Add Data from the Web

Power BI can pull data directly from a web page — a surprisingly powerful feature for pulling in public data tables, competitor pricing, market stats, or any structured HTML content.

Steps:

• Click Get Data → Web
• Paste the URL of the page containing the data
• Power BI scans the page and displays available tables in the Navigator
• Select the table you want
• Click Load or Transform Data

Common use cases: pulling financial data from government sites, importing product comparison tables, or scraping public leaderboards.

How to Enter Data Manually in Power BI

Sometimes you don’t have a file or database. You just need to type in a few rows of data. Power BI makes this straightforward.

Steps:

• Click Enter Data from the Home ribbon (not through Get Data)
• A grid editor opens — type in column names and values directly
• Click Load when done

This is ideal for small reference tables — like a region-to-sales-rep mapping or a custom category classification list that doesn’t exist anywhere else.

Limitation: Manual entry isn’t practical beyond a few dozen rows. For anything larger, export to Excel first and import from there.

How to Add Data from SharePoint or OneDrive

If your team lives in Microsoft 365, this is the connection you’ll use most. SharePoint and OneDrive let you connect to files that update automatically — so your Power BI report refreshes whenever the source file changes.

Steps:

• Click Get Data → SharePoint Online List (for SharePoint lists) or Web (for SharePoint-hosted Excel files)
• Paste the SharePoint site URL
• Authenticate with your Microsoft 365 account
• Select the list or file you want
• Click Load or Transform Data

Why this matters: According to Microsoft, organizations using connected cloud workflows save an average of 11 hours per employee per week. Auto-refreshing live reports are a big part of that.

How to Add Data Using Power BI Dataflows

Dataflows are Power BI’s answer to team-wide data reuse. Instead of every analyst building the same Excel connections and transformations, a dataflow lets one person do it once — and everyone else references it.

Steps to use a dataflow:

• In Power BI Service (web), go to your Workspace
• Click New → Dataflow
• Connect to your data source and apply transformations in Power Query
• Save and schedule refresh
• In Power BI Desktop, click Get Data → Power BI Dataflows
• Select the dataflow entity you want
• Click Load

Best for: enterprise teams where data consistency and governance matter. If 10 people are all building reports from the same source, a dataflow eliminates 10 versions of the same manual transformation.

How to Add Data from Cloud Services (Google Analytics, Salesforce, and More)

Power BI connects to dozens of cloud platforms through native connectors. This includes:

• Google Analytics — website traffic and behavior data
• Salesforce — CRM data, leads, and opportunities
• Dynamics 365 — business operations data
• Azure Blob Storage — raw files at scale
• Snowflake, BigQuery, Databricks — modern cloud data warehouses

Steps (general):

• Click Get Data → [Service Name] or search in the Get Data window
• Enter your account credentials
• Select the objects or tables you need
• Click Load or Transform Data

According to Dresner Advisory Services, cloud-based BI adoption has grown to over 55% of organizations globally — and the number keeps rising. These native connectors are what make Power BI a serious enterprise tool.

How to Use Power Query to Transform Data After Import

Getting data in is only half the job. Power Query — Power BI’s built-in data transformation engine — lets you clean, reshape, and combine data before it hits your report.

Common transformations:

• Remove duplicates — eliminates repeated rows
• Split columns — breaks “First Last” into two separate columns
• Filter rows — removes rows that don’t meet your criteria
• Merge queries — like a SQL JOIN, combines two tables on a shared key
• Change data types — ensures dates, numbers, and text are recognized correctly
• Replace values — swaps out blank cells, nulls, or inconsistent labels
• Unpivot columns — reshapes wide tables into long format for better analysis

To access Power Query: When importing any data, click Transform Data instead of Load. Or, from the Home ribbon, click Transform Data after the fact.

According to a TDWI report, data preparation consumes up to 80% of a data analyst’s time. Getting comfortable in Power Query directly reduces that number.

Common Mistakes When Adding Data in Power BI (and How to Fix Them)

Even experienced Power BI users hit the same walls repeatedly. Here’s what to watch for:

Importing raw, uncleaned data — always check data types and remove blanks in Power Query before loading. Dirty data produces misleading visuals.

Using Import when DirectQuery is needed — if your dataset exceeds 1 GB or requires real-time accuracy, DirectQuery is the right choice.

Hardcoding file paths — if your Excel file moves, your report breaks. Use relative paths or SharePoint/OneDrive connections for portability.

Skipping scheduled refresh — data that never updates defeats the purpose of a live dashboard. Set up automatic refresh in Power BI Service.

Not naming queries clearly — Power Query defaults to “Table1”, “Sheet2”, etc. Rename every query to something descriptive the moment you create it.

Mixing different granularity levels — combining daily sales data with monthly budget data without reconciling the grain causes calculation errors that are hard to spot.

Conclusion

Adding data in Power BI isn’t complicated once you know the right path for each source. Whether you’re starting from a simple Excel sheet or connecting to a live cloud data warehouse, the process follows the same core steps: open Get Data, select your source, preview and transform, then load.

The key is not just getting data in — it’s getting the right data in, clean. Use Power Query to shape it. Use the right connection mode for your use case. And build habits that scale — named queries, scheduled refreshes, and shared dataflows for teams.

The stat that should stick with you: Organizations that invest in clean, connected data workflows are 5x more likely to make faster decisions than their competitors, according to PwC. That starts with mastering the fundamentals — and you’re already there.