Load Multiple Tables

Power BI · Getting Data

Theory

Power BI gives you several ways to pull more than one table from a source like SQL Server at once, and picking the right one keeps your model clean and your reports fast. The three main approaches are: multi-selecting tables in the Navigator window, writing a custom SQL statement to shape exactly what comes back, or selecting an entire database in one go, which works but is rarely a good idea.

For the sample model you would tick dbo.Sales, dbo.Customers and dbo.Products in the Navigator, click Transform data to remove unused columns, then Close & Apply. Power BI loads each table as its own query and, if the source has foreign keys, can detect relationships automatically. What you load decides how fast, small and maintainable the whole report is.

Why we use it

Loading only the tables and columns a report needs keeps refresh fast, the .pbix file small, the source database less loaded and the field list tidy for report authors and readers.

When to use it

Use Navigator multi-select for most cases, a database view or custom SQL when you need one pre-joined or pre-filtered result, and avoid loading entire databases. Shape oversized tables with a date filter in Power Query.

How it works

  1. Connect to the database
  2. Open the Navigator list of tables
  3. Do you need a pre-joined or pre-filtered result? Yes: Use a source view or a single custom SQL statement. No: Tick only the tables the report needs.
  4. Transform data: drop unused columns and rows
  5. Close & Apply, then verify relationships in Model view
  6. Clean star-schema model ready for DAX

Syntax

Option 1: Home → Get data → SQL Server → Navigator → tick several tables → Transform data / Load
Option 2: Advanced options → SQL statement (only one result set is used; combine with UNION ALL or JOIN)
Option 3: Ctrl+A in Navigator (loads everything; avoid)
Then: Model view → check detected relationships

Example

1. Get data → SQL Server → server 'sql-prod-01', database 'SalesDB'.
2. In the Navigator tick Sales, Customers and Products (preview each one).
3. Click Transform data; in Sales remove unused audit columns.
4. Rename 'dim_customer' style names to Customers and Products.
5. Close & Apply, then open Model view and confirm:
   Customers[CustomerID] 1 → * Sales[CustomerID]
   Products[ProductID] 1 → * Sales[ProductID]

Key points

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic