Power BI is one of the most powerful tools for turning raw data into interactive dashboards and reports.
Connecting it to a SQL database (SQL Server, Azure SQL Database, or similar) is the most common and efficient way to analyze large datasets in real time.
Requirements
- Power BI Desktop (free download from Microsoft)
- Access to a SQL database (on-premises SQL Server, Azure SQL, or SQL Managed Instance)
- Server name, database name, and login credentials (Windows authentication or SQL Server authentication)
- Appropriate permissions on the database
Step 1: Open Power BI Desktop and Select Get Data
Launch Power BI Desktop. On the Home tab in the ribbon, click the Get data dropdown and choose SQL Server (it appears directly in the common data sources list).
Step 2: Enter Server and Database Details
- Server: Enter your server name (e.g., localhost, myserver\instance, or -Azure SQL like myserver.database.windows.net)
- Database (optional but recommended): Type the exact database name
- Data Connectivity mode: Choose Import (recommended for most users) or DirectQuery (for live data without importing)
click ok
Step 3: Provide Authentication Credentials
Power BI will prompt you to sign in.
-For Windows Authentication (most common on-premises): Select Use my current credentials
-For SQL Server Authentication: Choose Use alternate credentials and enter username/password
-For Azure SQL: Use Microsoft account or SQL authentication.
click connect
Step 4: Select Tables in the Navigator
-The Navigator window appears, showing all tables, views, and stored procedures in your database.
-Check the boxes for the tables you want
-Use the preview pane on the right to see sample data
(Optional) Click Transform Data to clean data in Power Query first
When ready, click Load.
Step 5: Build Your First Report
- Once loaded, switch to Report view. You’ll see your tables in the Fields pane on the right.
- Drag fields onto the canvas to create charts, tables, and visuals instantly.
Top comments (0)