Can Power BI Connect to Multiple Data Sources?

The short answer is yes, you absolutely can. Connecting to and combining data from multiple sources isn't just a feature in Power BI, it's one of its greatest strengths. This ability is what transforms Power BI from a simple chart-maker into a powerful business intelligence tool that helps you see the bigger picture. In this guide, we'll walk through how to connect to various data sources, combine them, and model them to create a unified report.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Connect Multiple Data Sources in the First Place?

Your business data doesn't live in one place. It’s scattered across spreadsheets, cloud applications, databases, and marketing platforms. Relying on just one source gives you a narrow, incomplete view of performance. When you pull them all together, you unlock a deeper level of understanding.

Get a Holistic View of Your Business

Imagine trying to understand customer behavior by only looking at your Shopify sales data. You know what they bought, but you don't know how they found your store, which ad campaigns they clicked on, or what support tickets they've submitted.

By connecting multiple sources, you can build a comprehensive view:

• Shopify Data: Tells you about orders, revenue, and products sold.
• Google Analytics Data: Shows you website traffic sources, user behavior, and conversion paths.
• Facebook Ads Data: Reveals ad spend, impressions, clicks, and campaign performance.
• Salesforce Data: Tracks customer interactions, lead status, and sales team activities.

Combining these sources allows you to trace the entire customer journey, from the first ad they saw to their most recent purchase and support ticket.

Uncover Deeper, More Actionable Insights

When data sources are linked, you can ask much more sophisticated questions. Instead of just reporting on metrics from each platform, you can analyze the relationships between them:

• "What is the return on ad spend (ROAS) for my Facebook campaigns when I account for actual sales data from Shopify?"
• "Do customers who come from organic search have a higher lifetime value than those from paid ads?"
• "How does a spike in website traffic from our blog impact the number of leads generated in HubSpot?"

Answering these questions is nearly impossible when your data lives in separate silos. Toggling between browser tabs and manually matching up dates in spreadsheets is a recipe for frustration and missed insights.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Connect Multiple Data Sources in Power BI: A Step-by-Step Guide

Connecting data sources is managed through Power Query, Power BI’s built-in data transformation engine. The process is straightforward, whether you're connecting to two sources or ten.

Step 1: Connect to Your First Data Source

First, open a blank Power BI Desktop file. The initial connection process is the same for every source you add.

1. Navigate to the Home tab in the ribbon.
2. Click the Get Data button. A dropdown menu will appear with common data sources (Excel workbook, SQL Server, etc.).
3. If you don't see your source, click More… at the bottom of the list to open the full Get Data window. Here you’ll find hundreds of native connectors.
4. For this example, let's select Excel Workbook and connect to a sales ledger file.
5. After locating your file, the Navigator window will open, showing you a preview of the tables and sheets within your workbook. Check the box next to the data you want to import and click Transform Data.

Clicking Transform Data (instead of Load) is crucial. This will open the Power Query Editor, which is where all the data magic happens.

Step 2: Connect to Your Second Data Source

With the Power Query Editor open, you’ll see your first data source listed as a "query" in the left-hand pane. To add another source, you just repeat the process from within the Power Query Editor.

1. In the Power Query Editor's Home tab, click New Source.
2. This brings up the same list of data sources you saw before. This time, let's connect to marketing data from a Text/CSV file.
3. Select Text/CSV, find your marketing campaign file, and Power Query will preview it.
4. Click OK.

Now, look at the Queries pane on the left. You see both data sources listed: one for your sales data and one for your marketing data. You can repeat this process for as many files, databases, or online services as you need.

Example Data sources:

• Sales Data (Excel): Contains Order ID, CustomerID, OrderDate, ProductSKU, and Revenue.
• Marketing Data (CSV): Contains campaign_id, date, ad Clicks, ad Spend, and impressions.
• Customer Data (SQL Database): Contains CustomerID, CustomerName, and State.

Even though they come from different systems and formats, they are now all available within the same Power Query window, ready to be cleaned and combined.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Combine Your Data

Simply having multiple data tables in your report isn't enough. The real value comes from making them work together. Power Query gives you two primary ways to do this: Merging and Appending.

Merging Queries (Joining Tables Side-by-Side)

Merging is used when you want to add columns from one table to another based on a shared, matching column. It’s identical to a VLOOKUP in Excel or a JOIN in SQL.

Let's say our Sales Data has a CustomerID, and our Customer Data from a database also has a CustomerID. We can merge these two tables to add the customer’s name and state to our sales records.

1. Select your main query (e.g., Sales Data) in the Queries pane.
2. On the Home tab in Power Query, click Merge Queries.
3. In the Merge window, the Sales Data table is already selected as the top table. In the dropdown below it, select the Customer Data query.
4. Now, click on the matching column in each table to tell Power BI how they relate. In this case, click on the CustomerID column in both tables. Power BI will show you how many rows match.
5. Choose your 'Join Kind' (Left Outer is the most common default, meaning it keeps all rows from the first table and adds matching data from the second).
6. Click OK.

A new column will appear in your Sales Data table. Click the expand icon (two arrows) in the column header to select which columns from the Customer Data table (like CustomerName and State) you want to add. And just like that, you've enriched your sales data with customer information from a completely separate source.

Appending Queries (Stacking Tables on Top of Each Other)

Appending is used when you have two or more tables with identical column structures and you want to stack them vertically into one single table. This is perfect for combining monthly or yearly data that has been exported into separate files.

For example, if you have a Sales_2022.csv, Sales_2023.csv, and Sales_2024.csv, you can append them to create a master sales table.

1. On the Home tab in Power Query, click Append Queries. Select Append Queries as New to create a new, combined table.
2. Choose whether you are combining two tables or three or more.
3. Add the tables you want to stack (e.g., Sales_2022, Sales_2023, etc.) to the 'Tables to append' list.
4. Click OK.

Power BI will create a new query that contains all the rows from all the specified tables in one long list.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 4: Load to Model and Create Relationships

Once you’ve cleaned, merged, and appended your data in Power Query, click the Close & Apply button in the top-left corner. This loads your prepared data into Power BI’s Data Model.

This is the final and most important step. Here, you define how the different tables (even those you didn’t merge) relate to each other.

1. In the main Power BI window, click on the Model view icon on the left-hand navigation bar (it looks like three connected boxes).
2. You'll see a diagram showing each of your tables. Power BI often automatically detects relationships, but it’s always best to verify them.
3. To create a relationship manually, simply click and drag the common field from one table to the corresponding field in another. For example, drag CustomerID from your master Customer table to CustomerID in your Sales table.

This relationship is what makes your dashboard interactive. When you create a chart showing sales by state (using State from the Customer table and Revenue from the Sales table), Power BI understands how to connect them. When you click on a specific product in one visual, it can now filter your sales figures, customer demographics, and marketing campaign data across your entire report page.

Final Thoughts

The ability to connect and combine multiple data sources is the key to unlocking true business intelligence in Power BI. By bringing data from different platforms into one environment, you can move beyond fractured reporting and create holistic dashboards that reveal how different parts of your business influence one another.

While Power BI offers incredible depth for those willing to master Power Query and DAX, we know firsthand that the learning curve can be steep for busy teams. That’s why we built Graphed to streamline this entire process. Instead of manually connecting sources, merging queries, and building data models, you just connect your platforms like Google Analytics, Shopify, and Salesforce once. From there, you can ask questions in plain English like, "Show me revenue by marketing channel last quarter" or "Create a dashboard tracking ad spend vs. sales," and our AI data analyst builds the dashboards for you instantly, no technical skills required. If you're looking for a faster way to get integrated insights, you can try Graphed for free.