Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP C C++ C# AWS W3.CSS HOW TO BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA TYPESCRIPT ANGULAR ANGULARJS GIT POSTGRESQL MONGODB ASP AI R GO KOTLIN SWIFT SASS VUE GEN AI SCIPY CYBERSECURITY DATA SCIENCE INTRO TO PROGRAMMING HTML & CSS BASH RUST TOOLS MATH

Power BI Get Data


Share

What Is a Data Source?

A data source is the place where your data lives.

It can be a file on your computer, a database on a server, a table on a web page, or an online service.

Power BI connects to the source, reads the data, and usually keeps a copy of it in your report.

Getting data is the first step of every Power BI project, as you saw in the Workflow chapter.

Power BI Desktop can connect to a long list of sources.

They are grouped in categories:

CategoryExamples
FileExcel Workbook, Text/CSV, XML, JSON, PDF, Folder
DatabaseSQL Server database, Access database, Oracle database, MySQL database, PostgreSQL database
Microsoft FabricPower BI semantic models, Dataflows, Lakehouses, Warehouses
Online ServicesSharePoint Online List, Salesforce Objects, Google Analytics
OtherWeb, SharePoint list, OData Feed, Blank Query

Each source you connect to becomes a query.

Each query loads into one table in the Data pane.


The Get data Button

You find Get data on the left of the Home tab.

The button has two parts:

  • Select the icon to open the Get Data window, with every source Power BI supports.
  • Select the label or its arrow to open a short list of Common data sources.

The short list has the sources most people use, such as Excel workbook, Text/CSV, Web and SQL Server.

Select More... at the bottom of the list to open the Get Data window.

The Get data dropdown on the Home tab of Power BI Desktop, showing the Common data sources list with More at the bottom

Next to Get data, the Home tab also has shortcut buttons for a few common sources, such as Excel workbook and SQL Server.

Enter data lets you type a small table by hand, and Recent sources lists the sources you used before.

The Get Data Window

The Get Data window lists the categories on the left: All, File, Database, Microsoft Fabric, Power Platform, Azure, Online Services and Other.

The sources in the selected category are listed on the right.

To connect:

  1. Select a category, or type the name of the source in the search box.
  2. Select the source, for example Excel Workbook.
  3. Select Connect.

The Get Data window in Power BI Desktop with the All category selected, the list of sources on the right, and the Connect button

What comes next depends on the source.

For a file, Power BI asks you to pick the file.

For a database or a web page, it asks for an address.

The next chapters show each of these.

Some sources are marked (Beta) or (Preview).

They are still being developed, and Microsoft does not recommend them for important reports.

Note: If a pop-up named Introducing the new Get Data experience! appears the first time you pick a source, select No thanks.

If Get data opens a full-page window with sections such as Home, New and Recent data, the preview feature New Power Query experience is turned on.

This tutorial uses the standard Get Data window.

To turn the preview off, go to File > Options and settings > Options > Preview features, clear New Power Query experience, and restart Power BI Desktop.



The Navigator

You met the Navigator in the First Report chapter, when you loaded the Sales sheet.

After Power BI connects to a source, the Navigator shows what the source holds:

  • On the left: a list of everything you can load, such as the sheets in a workbook, the tables in a database, or the tables on a web page.
  • On the right: a preview of the item you select.

Select the check box next to each item you want.

You can select several items at once.

Each one becomes its own table.

At the bottom of the Navigator are two buttons, Load and Transform Data.

Load or Transform Data?

ButtonWhat happensUse it when
LoadPower BI loads the selected items right away, as they are. They appear as tables in the Data pane.The data is already clean, like the Sales sheet in poke_mart_sales.xlsx.
Transform DataThe Power Query Editor opens. You clean and shape the data first, then select Close & Apply to load it.The data needs work: columns you do not need, wrong data types, or bad rows.

In the First Report chapter, Load was enough, because the practice data is clean.

In the Power Query chapter you will load a messy export with Transform Data and clean it step by step.

Choosing Load does not lock you in.

You can open the Power Query Editor at any time later with Transform data on the Home tab.


Several Sources in One Report

A report is not limited to one source.

The Poke Mart could keep its sales in an Excel workbook, publish its price list on a web page, and keep its sales targets in another workbook.

One report can use all three.

To add another source, select Get data again.

Each table you load appears in the Data pane next to the tables you already have.

Tables from different sources can work together in two ways:

  • Relationships: in Model view you link tables by a shared column, for example ProductID. See Relationships.
  • Combining in Power Query: you add columns from one table to another with Merge Queries, or stack tables with the same columns with Append Queries.

When a query combines data from two sources, Power BI may ask you to set a privacy level for each source, such as Public, Organizational or Private.

Privacy levels stop Power BI from sending private data from one source to another.

To see all the sources a report uses, select File > Options and settings > Data source settings, and choose Data sources in current file.


In This Chapter

The next pages show the most common sources and what happens after you connect:



Free account

Track your progress

XP earned 0 Day streak 0 Spaces 0 League —

New

Learn in Adventure Mode W3Schools Adventure App

Coding fundamentals as bite-sized lessons and challenges.

×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and privacy policy.

Copyright 1999-2026 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.