Power BI Connecting to Data Sources

Power BI is only as useful as the data you feed it. The first step in every Power BI project is connecting to a data source — the place where your data lives. Power BI supports an enormous range of sources, from simple Excel files on your desktop to live databases in the cloud.

What Is a Data Source

A data source is any location where data is stored. It could be a file, a database, a website, or an online service. When Power BI connects to a data source, it reads the data and brings it into your report so you can work with it.

Think of a data source like a water tank. Power BI is the pipe that carries water from the tank to your home (the report). Without the pipe, water stays in the tank and is inaccessible. Power BI makes the connection and brings the water to you.

How to Open the Get Data Window

In Power BI Desktop, click the Home tab in the ribbon. You will see a button labeled Get Data near the left side. Click it. A window opens showing all available data source categories.

If you hover over the small arrow on the Get Data button instead of clicking the main button, a dropdown shows the most commonly used sources — Excel, SQL Server, Web, and a few others. This is a shortcut for frequent connections.

Categories of Data Sources

The Get Data window organizes sources into categories:

File

This includes Excel workbooks, CSV files, XML files, JSON files, PDF files, and folders containing multiple files. Most beginners start here because their data often sits in Excel or CSV format.

Database

This includes SQL Server, MySQL, PostgreSQL, Oracle, and dozens of other databases. Connecting to a database usually requires a server address, database name, and login credentials provided by your IT team.

Power Platform

Connects to other Microsoft products like Power Apps dataflows, Common Data Service, and Analysis Services.

Azure

Connects to Microsoft cloud services like Azure SQL Database, Azure Blob Storage, and Azure Data Lake. Companies that store data in Microsoft's cloud use these connectors.

Online Services

Connects to platforms like SharePoint Online, Google Analytics, Salesforce, Dynamics 365, and many more. If your data lives in an online business tool, look here.

Other

A large collection of additional connectors — web pages, OData feeds, Python scripts, R scripts, and more. Advanced users explore this category when standard connectors do not cover their needs.

Connecting to an Excel File — Step by Step

Excel is the most common starting point. Here is how the connection works:

Click Get Data, then select Excel Workbook. A file browser opens. Navigate to your Excel file, select it, and click Open. A Navigator window appears showing all the sheets and tables inside the Excel file. Select the sheet or table you want, and you see a data preview on the right side.

You now have two choices: click Load to bring the data directly into Power BI as it is, or click Transform Data to open Power Query Editor where you can clean and modify the data before loading it. Most real-world projects use Transform Data because raw data rarely arrives in perfect condition.

Connecting to a Web Page

Power BI can read tables directly from websites. Select Get Data and choose Web. A box appears asking for a URL. Paste the webpage address that contains the table you want. Power BI fetches the page and shows you any tables it finds on that page.

For example, if a government website publishes a table of state-wise population data, you can paste that page URL into Power BI and pull the table directly — no copy-pasting required.

Live Connection vs Import Mode

When you connect to a data source, Power BI offers different connection modes depending on the source:

Import Mode

Power BI copies a snapshot of your data and stores it inside the report file. Reports load fast because the data is already loaded. The downside is that the data does not update on its own — you need to refresh it manually or set up a scheduled refresh.

This is like printing a photograph. The photo shows how things looked at that moment. If things change later, the photo does not update automatically.

DirectQuery Mode

Power BI does not copy the data. Instead, every time you interact with a report — click a filter, change a slicer — Power BI sends a live query to the database and retrieves fresh results in real time. This mode is useful when your data changes frequently and you need up-to-the-minute accuracy.

This is like a live video call. You see what is happening right now, not a recorded snapshot.

Live Connection

This mode connects to pre-built data models in Analysis Services or Power BI datasets. You use the model as-is without importing or querying the underlying database directly.

Connecting to Multiple Sources in One Report

A single Power BI report can pull data from multiple sources simultaneously. You can have an Excel file, a SQL database, and a SharePoint list all in the same report. Power BI loads each source as a separate table and lets you create relationships between them in the Model view.

For example, your sales data lives in a SQL database, your product catalog is in an Excel file, and your store locations are in a SharePoint list. Power BI brings all three together, connects them using common columns like Product ID or Store ID, and you can build reports that combine information from all three sources.

Key Points

• Click Get Data in the Home tab to start any data connection.
• Power BI connects to files, databases, cloud services, websites, and online platforms.
• Import Mode copies data into the report; DirectQuery fetches live data on demand.
• A single report can combine data from multiple different sources.
• Use Transform Data when you need to clean or reshape data before loading.