Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Import Data into Power BI

Cody Schneider••7 min read

Bringing your data into Microsoft Power BI is the first, VITAL step toward creating reports that C-suite dreams are made of. This is where your raw numbers start their journey to becoming clear, actionable insights.

GraphedGraphed

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.

Watch Graphed demo video

This tutorial will show you exactly how to import data into Power BI from some of the most common sources, like Excel spreadsheets, CSV files, and even live web pages and databases. We'll walk through the process step-by-step, so you can stop wrestling with connections and start visualizing your data.

What Is a Data Source in Power BI?

In Power BI, a "data source" is simply the place where your information lives. It could be a file on your computer, a database on a server, or a cloud-based application like Google Analytics or Salesforce. Power BI is incredibly versatile, armed with a huge library of built-in "connectors" designed to plug directly into these sources.

Think of connectors as special adapters. You wouldn't use the same plug for a European outlet as you would for a US one, and similarly, you use a specific connector for an SQL database versus an Excel file. The good news is that Power BI handles all the technical details for you, you just have to point it in the right direction.

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.

How to Import Your Data: A Step-by-Step Guide

The core process for importing data always starts in the same place: the Home tab in Power BI Desktop. The most prominent button you’ll see is Get Data. This is your gateway. Clicking a specific source type (like 'Excel workbook' or 'SQL server') is a shortcut, but clicking the 'Get Data' text or icon opens up the full menu of possibilities.

Let's walk through a few common scenarios.

1. Importing an Excel File into Power BI

For many, business data lives in Excel. It's the most common starting point for Power BI users, and luckily, it's also the easiest one to connect.

  1. Open Power BI Desktop. From the Home ribbon, click Excel workbook.
  2. Select Your File. A file browser window will pop up. Navigate to wherever your Excel file is saved and double-click it.
  3. Choose Your Data in the Navigator. A new window called 'Navigator' will appear. This shows you all the available tables and sheets within your Excel file. Any organized data range you've formatted as a Table will appear, as well as each individual worksheet. Click the checkbox next to the items you want to import. A preview of the selected data will appear on the right.

Load vs. Transform Data: A Critical Choice

At the bottom of the Navigator window, you'll see two options: Load and Transform Data.

  • Load: This option brings the data directly into your Power BI data model as-is. It's best if you know your data is perfectly clean and ready to go.
  • Transform Data: This is almost always the better choice. It opens the Power Query Editor, a powerful tool where you can clean and prepare your data before loading it. You can remove unnecessary columns, change data types (e.g., from 'text' to 'number'), filter out rows, and handle errors.

A good rule of thumb is to always click Transform Data, even if it's just to take a quick look. Prepping your data in Power Query makes your final reports faster, more accurate, and much easier to manage.

GraphedGraphed

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.

Watch Graphed demo video

2. Importing a CSV or Text File into Power BI

CSV (Comma-Separated Values) and TXT files are another common format, often used for exporting data from other systems.

  1. Go to the Home tab and click Get Data, then select Text/CSV.
  2. Locate and select your file on your computer.
  3. Power BI will show a preview window. Here, it will automatically try to detect the settings, but you can adjust them if needed.
  • Delimiter: This is the character used to separate values. Power BI usually auto-detects if it's a comma, tab, semicolon, or something else.
  • File Origin: This determines the character set. The default is usually fine unless you're working with files from different world regions with special characters.
  • Data Type Detection: Power BI will scan either the first 200 rows or the entire dataset to guess the data type for each column (e.g., Text, Number, Date).
  1. Again, choose Transform Data to check for any cleanup opportunities or Load to import it directly.

3. Connecting Power BI to a Web Data Source

This is a surprisingly powerful feature that lets you pull data directly from tables on a website. For example, you can grab a table of population data from a Wikipedia page.

  1. In the Home tab, click Get Data and select Web.
  2. A dialog box will ask for a URL. Paste the full web address of the page containing the data you want to import and click OK.
  3. Power BI will analyze the webpage and open the Navigator window, displaying a list of all the HTML tables it found.
  4. Click on each table name to preview it. Once you find the one you need, check the box next to it.
  5. Web data almost always needs cleaning up, so you should definitely click Transform Data. You might need to remove extra columns, promote a row to be the header, or clean up text formatting.

4. Connecting Power BI to an SQL Server Database

For many businesses, critical data is stored in an SQL database. Power BI connects to these sources seamlessly, but there's an extra consideration: the connectivity mode.

  1. Click Get Data and select SQL Server. Alternatively, you can find a dedicated button just for it on the Home ribbon.
  2. Enter the server's name or address in the Server field. You can also specify the Database name, but it's optional.
  3. Now, choose your Data Connectivity mode:
  4. After clicking OK, you might be asked for credentials if this is your first time connecting.
  5. The Navigator will then appear, allowing you to select the tables and views you want to include in your model.

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.

General Tips for Getting Your Data In

No matter where your data comes from, a few best practices will make your life easier and your reports more reliable.

  • It's All About Transformation: Spend time in the Power Query Editor ('Transform Data'). Cleaning data, removing columns you won't use, filtering out irrelevant rows, and ensuring correct data types at the start saves countless headaches later. A leaner, cleaner model is a faster model.
  • Think About Relationships: Once you import multiple tables (e.g., from an SQL database or a few Excel sheets), the next step is to define how they relate to each other in the 'Model View'. Telling Power BI that the 'CustomerID' in your Sales table is the same as the 'CustomerID' in your Customers table is what enables you to build insightful visuals that combine data from different sources.
  • Choose Connectivity Modes Wisely: The choice between Import and DirectQuery is one of the most important decisions you'll make when connecting to a database. Prioritize your need for speed versus real-time data. For most use-cases involving moderate amounts of data and daily refreshes, 'Import' is the preferred mode.

Final Thoughts

Knowing how to connect to different data sources is the foundation of everything you will do in Power BI. Whether it’s a simple Excel file or a complex database, the general workflow is consistent: find your source, use the navigator to select your data, and always take a moment to clean and transform it in Power Query before loading.

For those focused on marketing and sales data, connecting everything from Google Analytics, Shopify, HubSpot, and ad platforms can still feel like a manual chore, even with Power BI. We built Graphed to simplify this entire process. You can connect your marketing and sales stack with one-click integrations and then build real-time dashboards just by asking questions in natural language, skipping the manual setup and complex interfaces entirely.

Related Articles