Where is the Get Data Button in Power BI?

Jumping into Power BI for the first time starts with one critical step: adding your data. This essential process begins with the "Get Data" button, your gateway to connecting spreadsheets, databases, SaaS tools, and more. This guide will show you exactly where to find this button, what to do when you click it, and how to start connecting your most important data sources today.

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

The Main Location: Power BI Desktop's Home Ribbon

For anyone building reports, Power BI Desktop is the primary tool. It’s where you’ll spend most of your time shaping data and designing visuals. Thankfully, the "Get Data" function is placed right where you’d expect to find it.

You can find the "Get Data" button in the Home tab of the top ribbon. It's typically the very first and largest icon on the far left, making it easy to spot.

Two Other Quick Access Points

Microsoft knows that getting data is the first thing everyone does, so they've placed it in a couple of other convenient spots:

• The Center Canvas: When you open a brand new, empty Power BI report, the main canvas will have several starter links on it. One of them is a clickable "Get data" prompt right in the middle of the screen. This is a great shortcut when you're starting from scratch.
• The Dropdown Arrow: Right next to the main "Get Data" icon is a small downward-facing arrow. Clicking this reveals a list of the most common data sources, like Excel Workbook, SQL Server, and Web. If you know you’re pulling from a common source, this can save you a click.

What Happens After You Click "Get Data"? A Tour of the Connector Window

Clicking the main "Get Data" button doesn't immediately ask you to pick a file. Instead, it opens a powerful new window that showcases the true flexibility of Power BI. This window is your catalog of every official data connector available.

Here’s a quick breakdown of what you'll find:

• Search Bar: At the top left, there's a search bar. This is your best friend. Instead of scrolling, you can simply type "Salesforce," "Google," or "CSV" to instantly find the connector you need.
• Categories on the Left: To help with discovery, all connectors are organized into well-defined categories.

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

Practical Example: Connecting Power BI to an Excel Spreadsheet

Let’s walk through the most common data connection scenario: pulling data from an Excel workbook. It's a great way to get comfortable with the process.

Step 1: Open the "Get Data" Window

From the Home ribbon, click on the Get Data button. The connector window will pop up.

Step 2: Select "Excel workbook"

You can either find "Excel workbook" in the 'All' or 'File' category, or simply type "Excel" into the search bar. Once you've selected it, click the Connect button at the bottom right.

Step 3: Choose Your File

A standard file browser window will appear. Navigate to the folder where your Excel file is saved, select it, and click Open.

Step 4: Use the Navigator to Select Your Data

After a moment, a "Navigator" window will pop up. This is where Power BI gives you a preview of the contents of your Excel file. On the left side, you'll see a list of available sheets and tables within the workbook.

• Formatted Tables: If your Excel data is formatted as a proper table (using the "Format as Table" feature in Excel), it will appear with a distinct blue header icon. This is the best practice way to import Excel data, as it's neatly structured.
• Sheets: Regular worksheet tabs will also be listed. You can import an entire sheet, but if the sheet has messy formatting, you may have more data cleaning to do later.

Click on one of the items in the list to see a preview of the data on the right. Once you're confident it's the data you want, check the box next to its name on the left. You can select multiple tables or sheets if needed.

Step 5: Load or Transform the Data

At the bottom right of the Navigator, you have two primary options:

• Load: This option loads the selected data directly into your Power BI report's data model. If you know your data is clean and ready to go, this is the quickest option.
• Transform Data: This is the more powerful choice. It opens the Power Query Editor, a separate Power BI tool designed for cleaning, shaping, and transforming your data before it's loaded. Here you can remove columns, change data types, split text, and perform hundreds of other transformations.

For your first time, clicking Load is perfectly fine. The data will be added to your report, and you’ll see the fields appear in the "Data" pane on the right-hand side of Power BI Desktop.

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

"Get Data" in the Power BI Service (Online)

Once you publish your reports online to the Power BI Service (app.powerbi.com), you might notice there’s a "Get Data" option there, too. Its role is a bit different from the one in Power BI Desktop.

In the Power BI Service, "Get Data" is less about performing deep data transformations and more about connecting to existing datasets or performing simple file uploads. When you click the equivalent button in the service, you'll see options like:

• Discover content: Find data and reports published within your organization.
• Create new content: Here you can upload files like Excel, CSV, or Power BI Desktop (.pbix) files directly. You can also paste or enter data manually into a table.

The general workflow is: use Power BI Desktop for the serious work of connecting to sources and modeling data, then publish to the Power BI Service to share and collaborate.

Troubleshooting Common "Get Data" Issues

Sometimes you might run into a snag. Here are a couple of common problems and their quick fixes.

"I Can't Find the Connector I Need"

If you're looking for a specific connector (e.g., for a newer SaaS tool) and don't see it, it might be a 'preview' feature. You can enable these by going to File > Options and settings > Options. Under the 'Global' section, navigate to Preview features and check the box for the connector you want. You’ll need to restart Power BI for the change to take effect.

"The Get Data Button is Greyed Out"

This is rare but happens. Usually, it means you're in a window or view where adding a new data source isn't possible, like the Power Query Editor. If you're in Power Query, you'll use the "New Source" button in that window's ribbon instead. Otherwise, just make sure you're in the main "Report View" of Power BI Desktop.

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

"I'm Getting an Authentication or Credentials Error"

When connecting to databases or online services, Power BI needs to know you have permission to access the data. It will prompt you for credentials (like a username/password or by asking you to sign in via OAuth). If a connection fails, the first thing to check is that you are providing the correct credentials for that specific data source.

Final Thoughts

The "Get Data" function is the starting block for every project you'll build in Power BI. Whether it’s connecting to a simple Excel file or a complex cloud database, everything begins from that highly visible and versatile button on the Home ribbon. Taking a few moments to understand its layout and capabilities will make every future reporting task smoother and faster.

While tools like Power BI are incredibly powerful, connecting multiple marketing and sales platforms, cleaning the data, and building your reports from scratch can be a time-intensive process. When you factor in a dozen different logins and endless spreadsheets, consolidating everything into a single, real-time view can become a full-time job. We created Graphed because we believe getting insights shouldn't require a data engineering degree. We provide one-click integrations for your analytics, ad platforms, and CRMs, letting you instantly build unified dashboards and reports just by describing what you need in plain English. This approach helps you move from data chaos to clear answers in seconds, not hours.