How to Load Data to Power BI

Loading data is the first and most critical step in building any report, and Power BI offers a powerful gateway to connect to hundreds of different sources. Whether your information is in a simple spreadsheet or a complex cloud database, understanding how to import it correctly sets the foundation for a reliable and insightful dashboard. This guide will walk you through the most common methods for loading data into Power BI Desktop, from basic files to online services.

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

First, a Quick Note on "Load" vs. "Transform Data"

As you connect to data sources, Power BI will consistently give you two options: Load or Transform Data. It's a small choice that has a big impact.

• Load: This option brings the data directly into your Power BI data model as-is. It’s perfect when you know your data is already clean, perfectly formatted, and ready for analysis.
• Transform Data: This is the more common and recommended choice. It opens the Power Query Editor, an incredibly powerful tool where you can clean, shape, and prepare your data before it gets loaded. Here you can remove unnecessary columns, filter out rows, correct data types, and merge tables.

A good rule of thumb is to almost always select "Transform Data" just to take a quick look. It's better to verify your data's quality before you start building visuals based on it.

How to Load Data from Common File Types

The simplest way to get started with Power BI is by using local files. You can find all the primary options in the "Home" tab of the ribbon by clicking on the "Get Data" dropdown.

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

From an Excel Workbook (.xlsx)

Excel spreadsheets are perhaps the most common data source for new Power BI users. The process is straightforward.

Step-by-step instructions:

1. On the Home tab, click Get Data and select Excel Workbook.
2. Navigate to your Excel file and click Open.
3. The Navigator window will appear. This window shows you all the sheets and any formatted tables within the workbook.

A pro tip: always format your data as a table in Excel (select your data and press Ctrl+T) before connecting in Power BI. Tables are more structured and reliable than open-ended worksheets. You'll recognize tables in the Navigator by their distinct blue header icon, whereas sheets have a simpler grid icon.

Once you select a table or sheet, a preview will appear on the right. From here, you can click Load or Transform Data.

From a CSV or Text File (.csv, .txt)

CSV (Comma-Separated Values) files are another basic but very common way to store data. Power BI handles them with ease.

Step-by-step instructions:

1. Click Get Data > Text/CSV.
2. Browse to your file and open it.
3. A preview window will immediately pop up. Power BI makes a few automatic guesses here that you should always verify:

Once you are satisfied with the settings, choose Load to import it directly or Transform Data to open the Power Query Editor for adjustments.

From a Folder

One of Power BI's most powerful yet underutilized features is its ability to connect to an entire folder of files. This is perfect for situations where you receive the same report on a recurring basis, like monthly sales exports or weekly web analytics dumps.

This feature allows you to combine all files in a folder into a single table automatically, as long as they have the same structure (same columns in the same order).

Step-by-step instructions:

1. Go to Get Data > More... > Folder and click Connect.
2. Browse to the folder containing your files (e.g., all your monthly CSV exports). Do not enter the folder, just select it and click OK.
3. A metadata view appears, showing details for each file in the folder. To merge them, click the Combine dropdown at the bottom and select Combine & Transform Data.
4. Power BI will ask you to use the first file as an example to set up the import logic (e.g., delimiter for a CSV). Confirm those settings.

Power BI will then work its magic, creating a single query that consolidates all the files. When you add a new file to that folder and refresh your report, the new data will be added automatically!

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

Connecting to Databases and Online Services

Power BI truly shines when connecting to more modern, centralized data sources like databases and cloud platforms.

From a Database (like SQL Server)

Connecting to a database is just as simple as connecting to a file, but with one very important consideration: the Data Connectivity mode.

Step-by-step instructions:

1. Go to Get Data > SQL Server.
2. Enter the server name and, optionally, the database name.
3. Now, you must choose a Data Connectivity mode:

Once you've made your choice and provided your credentials, the Navigator window will appear, allowing you to select which tables or views you want to use.

From a Web Page

Need to pull public data from a website, like a table from a Wikipedia page? The web connector can do this in seconds.

Step-by-step instructions:

1. Go to Get Data > Web.
2. In the dialog box, simply paste the full URL of the web page.
3. Power BI will scan the page's HTML and the Navigator will show you all the tables it was able to identify.
4. Just select the table you want, preview it, and click Load or Transform Data. In many cases, it will require some quick cleanup in the Power Query Editor.

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

From Online Services (e.g., SharePoint, OData, etc.)

Power BI's "Get Data" dialog box is packed with native connectors for countless online platforms, including OData feeds, SharePoint Lists, Salesforce, Dynamics 365, and Azure services. The connection process for these is generally similar:

1. You find the specific service in the "Get Data" options.
2. You provide an address or root URL.
3. You are prompted to sign in with your credentials for that specific service.

Once authenticated, the experience is nearly identical to connecting to a local database, letting you browse and select the data objects you need.

Final Thoughts

Learning to load data is your first step toward mastering Power BI. By understanding the core connection methods for files, databases, and online services - and knowing when to use "Import" versus "DirectQuery" - you can build a solid, reliable foundation for any report you need to create. Always take a moment to explore the data with "Transform Data" to ensure its quality.

While Power BI offers extensive connectors, manually pulling data from different marketing and sales platforms, each with its own login and data structure, can quickly become overwhelming. At Graphed we streamline this entire process for you. We provide one-click integrations for sources like Google Analytics, Shopify, Facebook Ads, and Salesforce, putting all your performance data into a single place. From there, you can create real-time dashboards and get answers instantly just by asking questions in plain English, skipping the manual setup entirely.