SQL Server connection in Power BI - Step-by-Step Guide

Introduction

This feature lets you connect Power BI to a SQL Server database. It helps you get data directly from your database to create reports and dashboards without manual exports.

When you want to build a sales report using live data stored in SQL Server.

When your team updates data daily in SQL Server and you want your dashboard to reflect changes automatically.

When you need to combine SQL Server data with other data sources in Power BI.

When you want to avoid exporting data manually from SQL Server to Excel before analysis.

When you want to schedule data refreshes from SQL Server in Power BI service.

Steps

Step 1: Click

- Home tab > Get Data button

The Get Data window opens showing data source options

Step 2: Select

- Get Data window > Database category > SQL Server database

The SQL Server database connection window appears

Step 3: Type

- SQL Server database window > Server field

The server name is entered for connection

Step 4: Type

- SQL Server database window > Database field (optional)

The specific database name is entered to narrow data source

Step 5: Choose

- SQL Server database window > Data connectivity mode

Select either Import or DirectQuery mode for data access

Step 6: Click

- SQL Server database window > OK button

Power BI connects to SQL Server and shows Navigator pane with tables

Step 7: Select

- Navigator pane

Chosen tables or views appear ready to load or transform

Step 8: Click

- Navigator pane > Load button

Data loads into Power BI for report building

Before vs After

Before

Power BI has no data loaded; the report canvas is empty

After

Power BI shows tables from SQL Server loaded and ready for report creation

Settings Reference

Server

📍 SQL Server database connection window

Specifies the SQL Server instance to connect to

Database

📍 SQL Server database connection window

Limits connection to a specific database on the server

Data connectivity mode

📍 SQL Server database connection window

Determines if data is imported or queried live

Default: Import

Authentication method

📍 SQL Server database connection window (after clicking OK if prompted)

Defines how Power BI authenticates to SQL Server

Default: Windows Authentication

Common Mistakes

Entering incorrect server name or missing instance name

Power BI cannot connect if the server name is wrong or incomplete

Verify the exact server name and instance from your database admin before connecting

Choosing Import mode when live data is needed

Import mode loads data once and does not reflect real-time changes

Select DirectQuery mode to query live data if up-to-date info is required

Not selecting the correct authentication method

Connection fails if authentication does not match SQL Server settings

Confirm with your admin which authentication to use and enter correct credentials

Summary

Power BI connects directly to SQL Server to fetch data for reports.

You can choose to import data or query it live with DirectQuery.

Make sure to enter correct server details and authentication to connect successfully.