DEV Community: Temiloluwa Bolaji

From Data Sources to Insights: Integrating Data in Power BI

Temiloluwa Bolaji — Sat, 04 Apr 2026 13:21:16 +0000

Introduction

In modern analytics environments, data is often spread across multiple sources such as Excel files, databases, cloud platforms, and web services. This fragmentation makes it challenging to gain clear, consistent insights.

Power BI addresses this by providing a centralized platform to connect to diverse data sources, transform raw data into a structured format, and integrate it into a single, reliable model for analysis.

This article explores how Power BI enables efficient data integration, covering the types of data sources available, connection methods, transformation processes, and practical examples to guide implementation.

How to Get Data from Different Sources in Power BI

This section explains the step-by-step process of importing data from key sources in Power BI. The general workflow starts from Home → Get Data, then varies slightly depending on the source.

Step 1:Importing Data from Excel

Open Power BI Desktop
Go to Home → Get Data → Excel Workbook
Browse and select your Excel file
Click Open
In the Navigator, select the sheet(s) or table(s)
Click: Load (to import directly), or Transform Data (to clean first)

Step 2: Import data from CSV

Go to Home → Get Data → Text/CSV
Select the CSV file and preview data in the dialog box
Click: Load, or Transform Data

Step 3: Importing Data from JSON

Go to Home → Get Data → JSON
Select the JSON file
Click Open
Power BI opens Power Query Editor
Expand records and lists using: Expand (double-arrow icon)
Transform into a table format
Click Close & Apply

Key Note:

JSON data often requires multiple transformation steps due to its nested structure.

Step 4: Importing Data from SQL Server

Go to Home → Get Data → SQL Server
Enter: Server name, Database name (optional)
Choose connection mode:
- Import (stores data in Power BI)
- DirectQuery (queries data live)
Click OK and enter credentials (Windows/Database login)
Select tables in Navigator
Click Load or Transform Data

Key Note:

Use DirectQuery for large datasets that require real-time access.

Step 5:Importing Data from PDF

Go to Home → Get Data → PDF
Select the PDF file
In the Navigator, preview available tables
Select the required table(s)
Click Load or Transform Data

Key Note:

Review extracted tables carefully, as formatting issues may occur.

Step 6:Importing Data from Cloud Platforms

SharePoint / Azure / Online Services

Go to Home → Get Data → More
Select the relevant service (e.g., SharePoint Folder, Azure SQL, etc.)
Enter the URL or server details
Click Connect
Sign in using your credentials (OAuth)
Select datasets in Navigator
Click Load or Transform Data

Key Note:

Cloud sources support:

Scheduled refresh
Real-time updates
Collaboration across teams

Conclusion

Getting data from different sources is a key part of using Power BI effectively. Whether the data comes from Excel, CSV, SQL Server, JSON, PDFs, or cloud platforms, Power BI makes it easy to connect, transform, and combine them in one place.

The process is simple: Connect → Preview → Transform → Load. Once the data is properly prepared, it becomes easier to create accurate and meaningful reports.

In summary, understanding how to import and manage data from multiple sources helps you build better dashboards and make more reliable decisions.

From Data Sources to Insights: Integrating Data in Power BI

Temiloluwa Bolaji — Sat, 04 Apr 2026 13:21:16 +0000

Introduction

How to Get Data from Different Sources in Power BI

This section explains the step-by-step process of importing data from key sources in Power BI. The general workflow starts from Home → Get Data, then varies slightly depending on the source.

Step 1:Importing Data from Excel

Open Power BI Desktop
Go to Home → Get Data → Excel Workbook
Browse and select your Excel file
Click Open
In the Navigator, select the sheet(s) or table(s)
Click: Load (to import directly), or Transform Data (to clean first)

Step 2: Import data from CSV

Go to Home → Get Data → Text/CSV
Select the CSV file and preview data in the dialog box
Click: Load, or Transform Data

Step 3: Importing Data from JSON

Go to Home → Get Data → JSON
Select the JSON file
Click Open
Power BI opens Power Query Editor
Expand records and lists using: Expand (double-arrow icon)
Transform into a table format
Click Close & Apply

Key Note:

JSON data often requires multiple transformation steps due to its nested structure.

Step 4: Importing Data from SQL Server

Go to Home → Get Data → SQL Server
Enter: Server name, Database name (optional)
Choose connection mode:
- Import (stores data in Power BI)
- DirectQuery (queries data live)
Click OK and enter credentials (Windows/Database login)
Select tables in Navigator
Click Load or Transform Data

Key Note:

Use DirectQuery for large datasets that require real-time access.

Step 5:Importing Data from PDF

Go to Home → Get Data → PDF
Select the PDF file
In the Navigator, preview available tables
Select the required table(s)
Click Load or Transform Data

Key Note:

Review extracted tables carefully, as formatting issues may occur.

Step 6:Importing Data from Cloud Platforms

SharePoint / Azure / Online Services

Go to Home → Get Data → More
Select the relevant service (e.g., SharePoint Folder, Azure SQL, etc.)
Enter the URL or server details
Click Connect
Sign in using your credentials (OAuth)
Select datasets in Navigator
Click Load or Transform Data

Key Note:

Cloud sources support:

Scheduled refresh
Real-time updates
Collaboration across teams

Conclusion

The process is simple: Connect → Preview → Transform → Load. Once the data is properly prepared, it becomes easier to create accurate and meaningful reports.

In summary, understanding how to import and manage data from multiple sources helps you build better dashboards and make more reliable decisions.