What is GetData in Power BI?

The first step in any Power BI project is getting your data into the application, and the "Get Data" feature is your gateway to do just that. It’s the starting point for transforming raw numbers into clear, interactive visuals. This article will walk you through what the "Get Data" experience is, how to use it, and some of the most common data sources you can connect to.

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

What is "Get Data" in Power BI?

Simply put, "Get Data" is the built-in function in Power BI Desktop that allows you to connect to an enormous variety of data sources. Think of it as the welcome mat for your data. Whether your information lives in a simple Excel spreadsheet, a corporate SQL database, a cloud service like Salesforce, or a folder of CSV files, "Get Data" is the tool you'll use to establish a connection and pull that data into your Power BI report.

This process is the "Extract" part of a common data workflow known as ETL (Extract, Transform, Load). "Get Data" handles the extraction, pulling the raw data from its source. Once extracted, the data is typically sent to the Power Query Editor, where you can perform the "Transform" steps - cleaning, shaping, and modeling your data before you "Load" it into Power BI to build visuals.

How to Use "Get Data" in Power BI Desktop

Getting started with "Get Data" is a straightforward process. Let’s walk through the steps using a common example: connecting to an Excel workbook.

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

Step 1: Locate the "Get Data" Button

First, open a blank project in Power BI Desktop. The "Get Data" button is prominently displayed in the Home tab on the main ribbon. You will see an icon for it, as well as several shortcuts for common sources like Excel workbook, SQL Server, and Text/CSV.

You can either click one of the shortcuts or click the main "Get Data" icon to open the full menu of available connectors.

Step 2: Choose Your Data Source

Clicking the "Get Data" icon will launch a new window that showcases all the native data connectors available in Power BI. They are neatly organized into categories on the left, such as:

• File (Excel, CSV, PDF, SharePoint folder)
• Database (SQL Server, MySQL, PostgreSQL, Access)
• Power Platform (Dataverse, Power BI datasets)
• Azure (Azure SQL Database, Azure Synapse Analytics)
• Online Services (Salesforce, Google Analytics, HubSpot)

You can use the search bar at the top to quickly find what you're looking for. For our example, select Excel workbook and click Connect.

Step 3: Navigate to Your File

Windows Explorer (or Finder on Mac) will open, prompting you to locate the Excel file on your computer. Find the file, select it, and click Open.

Step 4: Use the Navigator to Select Data

Once you select your file, the Navigator window will appear. This window shows you all the available tables and worksheets within your Excel file. You can click on any item in the list to see a preview of its data on the right-hand side.

It's a best practice to structure your Excel data as a formatted Table, as these are easier for Power BI to work with. Select the tables or sheets you want to import by checking the box next to them. You can select multiple items at once.

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

Step 5: Choose Between "Load" or "Transform Data"

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

• Load: This will pull the data directly into your Power BI model as-is. This is only useful if you are 100% sure your data is perfectly clean and requires no changes.
• Transform Data: (the recommended option) Open the Power Query Editor to clean your data before loading it. You can remove columns, change data types, filter out rows, split columns, and perform hundreds of other transformations to prepare your data for analysis.

Always default to choosing Transform Data. Raw data is rarely perfect, and spending time shaping it in Power Query will save you from major headaches down the road. After making your changes in Power Query, you will click "Close & Apply" to load the final, cleaned data into your report.

A Tour of Common Power BI Data Sources

The real power of "Get Data" is its versatility. You can pull information from almost anywhere. Here are some of the most popular categories and sources businesses use every day.

Files

These are the most common starting points for many Power BI users, especially those working with data exports from other systems.

• Excel Workbooks (.xlsx): The go-to for finance, sales, and operational data. You can connect to specific tables or entire sheets.
• Text/CSV (.csv): A universal, plain-text format for tabular data. Almost any application can export to CSV, making it a reliable interchange format.
• PDF: A surprisingly powerful feature. Power BI can automatically detect and extract tables from PDF documents, which is great for digitizing data from static, published reports.
• Folder: A huge time-saver. Instead of connecting to individual files one by one, you can connect to a folder. Power BI will then combine all the compatible files within that folder into a single table. This is perfect for consolidating monthly sales reports, log files, or daily exports.

Databases

For more robust and larger-scale data, connecting directly to a database is ideal. This is where you encounter an important concept in Power BI: storage modes.

• SQL Server: A flagship connector from Microsoft. When you connect, you’ll be asked to choose a Data Connectivity mode:
• Other Databases: Power BI also supports a wide range of other popular databases, including MySQL, PostgreSQL, Oracle, SQLite, and many more.

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

Online Services & SaaS Platforms

This is where Power BI really shines for teams in marketing, sales, and operations. You can pull data directly from the cloud tools you use every day without manually exporting CSV files.

• SharePoint Online List: Pull data directly from lists managed in SharePoint.
• Salesforce: Connect to both standard and custom objects in your Salesforce org to analyze your sales pipeline, track leads, and monitor team performance.
• Google Analytics: Analyze website traffic, user behavior, and conversion metrics directly.
• HubSpot: Connect to HubSpot marketing, sales, and contact data to create holistic business dashboards.

Connecting to these services typically involves a simple sign-in (OAuth) process where you grant Power BI permission to access your data.

Tips and Best Practices for Getting Data

Keep these tips in mind to make your data connection process as smooth as possible.

1. Scrutinize Your Data Preview: Don't just blaze through the Navigator. Use the preview to check if the data looks as you expect. Are the columns correct? Is there junk data in the first few rows that needs to be removed?
2. Check Data Types in Power Query: After loading your data into the Power Query Editor, your first step should always be to review the data type assigned to each column. Power BI does a good job of detecting them automatically, but it can sometimes miscategorize a numeric column as text or a date column as a general number. Correcting these early on is essential for accurate calculations.
3. Filter Early to Improve Performance: When connecting to a very large dataset like a database, you don't always need to import every single row. Filter the data as early as possible - either in the native SQL query window if available or as one of the very first steps in Power Query. Working with a smaller, relevant subset of data will make your development process much faster.
4. Manage Credentials in Data Source Settings: In Power BI Desktop, you can manage the login credentials for all your sources under File > Options and settings > Data source settings. Here, you can update passwords, change permissions, or clear connection settings if something has gone wrong, so you don't have to re-authenticate every time.

Final Thoughts

Mastering the "Get Data" experience is the most important skill in Power BI. It's the foundation upon which every great report is built, allowing you to connect a vast universe of data sources, from local files on your computer to sophisticated cloud services. By understanding how to connect, select, and prepare your data, you unlock the path to creating powerful, insight-driven visualizations.

While Power BI's connectors are extensive, setting up and managing data from multiple marketing and sales platforms like Google Analytics, Shopify, Facebook Ads, and Salesforce can still feel like a chore. At Graphed, we’ve built a platform that simplifies this entire process. We offer one-click integrations with the tools you use every day, so you can connect all your data sources in seconds. From there, you can start asking for reports and dashboards in plain English, and our AI data analyst builds them for you, letting you jump from initial connection to valuable insight in a fraction of the time.