Getting Data from Multiple Sources in Power BI:A Beginner-Friendly Approach

Introduction

In many real-world data projects, information does not come from a single source. Instead, it is often spread across platforms such as Excel files, CSV files, databases, web APIs, PDFs, and cloud storage such as SharePoint. To generate meaningful insights, this data must be collected, combined, and prepared in one place.
Power BI provides a simple and efficient way to connect to these different data sources. It allows users to import data, review it, and transform it before building reports and dashboards.

In this guide, you will learn how to:

• Connect Power BI to multiple data sources
• Review and explore data using Power Query
• Prepare data for analysis and reporting

Architecture Overview

In Power BI, architecture refers to how data flows from different sources into the final report.
Power BI Desktop serves as the central tool used to connect to data, clean it, and build visual reports.
Data can come from multiple sources, including:
• Excel and CSV files
• SQL Server databases
• JSON and PDF files
• SharePoint folders

All data is first loaded into Power Query, which is the data preparation layer in Power BI. In this stage, the data is reviewed, cleaned, and transformed into a usable format.
Once the data is properly prepared, it is loaded into the Power BI data model. This is where relationships are created, and the data becomes ready for analysis and visualization.
This structured flow ensures that the data used in reports is clean, consistent, and reliable.

Connecting Data from Multiple Sources

Power BI makes it easy to bring in data from different sources. Below are simple steps to help you connect to each type of data.

Step 1: Excel*

1. Open Power BI Desktop
2. Click Home → Get Data → Excel

1. Choose your Excel file

1. Select the sheet or table you need
2. Click Load or Transform Data

Step 2: Text/CSV

1. Open Power BI Desktop
2. Click Home → Get Data → Text/CSV

1. Select your CSV file

1. Preview the data
2. Click Load or Transform Data

Step 3: PDF

1. Open Power BI Desktop
2. Click Home → Get Data → PDF

1. Select the PDF file

1. Choose the table you want
2. Click Load or Transform Data

Step 4: JSON

1. Open Power BI Desktop
2. Click Home → Get Data → JSON

1. Select the file or API

1. Expand the data to make it readable

1. Click Close & Apply

Step 5: SharePoint Folder

1. Open Power BI Desktop
2. Click Home → Get Data → SharePoint Folder

1. Enter the link

1. Sign in if needed
2. Select files
3. Click Combine & Transform Data

Step 6: MySQL Database

1. Open Power BI Desktop
2. Click Home → Get Data → MySQL Database

1. Enter server and database name

1. Sign in

1. Select tables
2. Click Load or Transform Data

Step 7: SQL Server

1. Open Power BI Desktop
2. Click Home → Get Data → SQL Server

1. Enter server name
2. Click OK

1. Sign in

1. Select tables
2. Click Transform Data

Step 8: Web Data

1. Open Power BI Desktop
2. Click Home → Get Data → Web

1. Enter the website link

1. Select the data
2. Click Load or Transform Data

Step 9: Azure Analysis Services

1. Open Power BI Desktop
2. Click Home → Get Data → Azure → Azure Analysis Services

1. Enter server name
2. Select model
3. Click Connect

Conclusion

Connecting data from multiple sources is a key step in building effective Power BI reports. Since data is often stored in different formats and locations, Power BI provides a flexible way to bring everything together on a single platform.
With the help of Power Query, data can be cleaned, structured, and prepared before it is used for analysis. This preparation stage is important because it ensures that the data is accurate and consistent.
Well-prepared data leads to better insights, clearer reports, and more informed decision-making.
In summary, successful data analysis in Power BI starts with properly connecting and preparing your data. When this step is done correctly, it becomes easier to create meaningful and reliable dashboards.