# Connecting Azure SQL Database to Power BI — My First Data Visualization Project

As someone interested in cloud, I wanted to explore how Azure integrates with Power BI to build real-time dashboards. This project helped me understand how to:

* Deploy a SQL database on Azure
    
* Load sample data (AdventureWorksLT)
    
* Connect it to Power BI
    
* Build basic graphs and visuals
    

Here’s how I did it!

## Step 1: Create the Azure SQL Database

I started in the [Azure Portal](https://portal.azure.com) and followed these steps:

1. Searched for **“SQL Databases”** → clicked **\+ Create**
    
2. Configured:
    
    * **Database name**: `adventureworksdb`
        
    * **Server**: Created a new SQL server with login credentials
        
    * **Sample data**: Chose **AdventureWorksLT** (great for learning)
        
3. Chose **Basic** compute tier to minimize cost
    
4. Enabled:
    
    * "Allow Azure services to access this server"
        
    * Client IP access for Power BI connection
        
        ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1750251869007/177a548e-48f5-49b5-b591-74ed47ac908b.jpeg align="center")
        

Then I deployed it — and the database was ready in a few minutes!

## Step 2: Connect to Power BI

After the database was deployed, I opened **Power BI Desktop** and followed this flow:

1. **Home → Get Data → SQL Server**
    
2. Entered:
    
    * **Server name**: [`yourservername.database.windows.net`](http://yourservername.database.windows.net)
        
    * **Database**: `adventureworksdb`
        
    * ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1750252107053/b5ff9b08-ee55-4a95-a33f-ca9f933cbefb.jpeg align="center")
        
3. Authentication:
    
    * Chose **SQL Server Authentication**
        
    * Entered username & password from Azure
        
    * ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1750252197241/a28e3524-aa1d-4559-9a7d-d3a65690fb04.jpeg align="center")
        

Power BI connected smoothly and loaded the sample tables.

## Step 3: Build Visuals

I explored tables like:

* `SalesLT.Customer`
    
* `SalesLT.Product`
    
* `SalesLT.SalesOrderHeader`
    

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1750252462400/e064f16c-ba60-4fb6-a7c4-071ae3872391.jpeg align="center")

Then I created visuals such as:

* Bar chart of **sales by product category**
    
* Line graph of **sales trends over time**
    
* Pie chart of **orders by region**
    
* ![](https://cdn.hashnode.com/res/hashnode/image/upload/v1750252475678/50258e91-9a0b-4e14-b118-97464e97fb6f.jpeg align="center")
    

Power BI made it easy to drag and drop fields — and seeing real-time cloud data visualized felt powerful.

**Thanks for reading!**  
This project helped me connect two powerful tools — Azure and Power BI — and gave me a real sense of how cloud data flows into visual reports.

If you’re learning cloud or data tools, this is a great beginner-friendly combo to try.  
Let’s keep building and learning together! 🚀

— *Jyothi*