{"id":288188,"date":"2025-06-11T14:54:06","date_gmt":"2025-06-11T14:54:06","guid":{"rendered":"https:\/\/peraltafinancing.com\/analytics\/how-to-connect-to-multiple-data-sources-in-power-bi\/"},"modified":"2025-06-11T14:54:06","modified_gmt":"2025-06-11T14:54:06","slug":"how-to-connect-to-multiple-data-sources-in-power-bi","status":"publish","type":"post","link":"https:\/\/fivemor.com\/?p=288188","title":{"rendered":"How to Connect to Multiple Data Sources in Power BI?"},"content":{"rendered":"<p> <br \/>\n<\/p>\n<div id=\"article-start\">\n<p><span style=\"font-weight: 400;\">You have Power BI on your system, and you wonder, \u201cCan I actually fetch data from more than one source?\u201d Like maybe six different sources, or some Excel files, with an SQL database, or even pull in some live exchange rates from the web?<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Let me answer that in short \u2013 yes, you totally can. And it\u2019s literally one of the best things about Power BI \u2013 it\u2019s built for connecting, blending, and visualizing data from multiple sources.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In this article, I\u2019ll walk you through how to connect to multiple data sources in Power BI, using real-world examples. I\u2019ll also share some important tips about combining data properly so your reports don\u2019t fall apart later.<\/span><\/p>\n<h2 class=\"wp-block-heading\" id=\"h-understanding-data-sources-in-power-bi\"><span style=\"font-weight: 400;\">Understanding Data Sources in Power BI<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Before jumping in, let\u2019s just clarify what exactly counts as a \u2018data source\u2019?.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Well, in Power BI, a data source can be almost anything that holds data. It could be:<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">A file like Excel or CSV<\/span><\/li>\n<li><span style=\"font-weight: 400;\">A database (SQL Server, <a href=\"https:\/\/www.analyticsvidhya.com\/blog\/2022\/09\/interacting-with-remote-databases-postgresql-and-dbapis\/\" target=\"_blank\" rel=\"noreferrer noopener\">PostgreSQL<\/a>, etc.)<\/span><\/li>\n<li><span style=\"font-weight: 400;\">A cloud platform (like Azure or SharePoint)<\/span><\/li>\n<li><span style=\"font-weight: 400;\">A live data feed or web API<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Even another Power BI dataset<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">And yeah, you can <\/span><b>connect to more than one of these at the same time<\/b><span style=\"font-weight: 400;\"> in a single report. But you need to manage them well (especially when it comes to the relationships and refresh).<\/span><\/p>\n<h3 class=\"wp-block-heading\" id=\"h-types-of-data-sources\"><span style=\"font-weight: 400;\">Types of Data Sources<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">To give you some perspective, here\u2019s how the sources generally fall into categories:<\/span><\/p>\n<div class=\"table-responsive mb-3\">\n<table class=\"table table-hover table-bordered\">\n<thead\/>\n<tbody>\n<tr>\n<td><b>Category<\/b><\/td>\n<td><b>Examples<\/b><\/td>\n<\/tr>\n<tr>\n<td><strong>Files<\/strong><\/td>\n<td><span style=\"font-weight: 400;\">Excel, CSV, XML, JSON, PDF<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong>Databases<\/strong><\/td>\n<td><span style=\"font-weight: 400;\">SQL Server, MySQL, PostgreSQL<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong>Cloud Services<\/strong><\/td>\n<td><span style=\"font-weight: 400;\">SharePoint, OneDrive, Azure<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong>Web &amp; APIs<\/strong><\/td>\n<td><span style=\"font-weight: 400;\">Websites with tables, REST APIs<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400;\">Here\u2019s all of them listed in Power BI.<\/span><\/p>\n<figure class=\"wp-block-image size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"667\" height=\"650\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-1-1.webp\" alt=\"Types of Data Sources in Power BI\" class=\"wp-image-237131\" style=\"width:718px;height:auto\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-1-1.webp 667w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-1-1-300x292.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-1-1-150x146.webp 150w\" sizes=\"(max-width: 667px) 100vw, 667px\"\/><\/figure>\n<p><span style=\"font-weight: 400;\">Power BI really shines when it comes to connecting with all sorts of data sources. Whether your data lives in a simple Excel file, a solid SQL Server database, a cloud service, or even a live web API, Power BI can pull it all in seamlessly. This incredible flexibility means you can easily bring together information from literally anywhere, allowing you to build comprehensive dashboards and unlock insights that paint the full picture for your business.<\/span><\/p>\n<h2 class=\"wp-block-heading\" id=\"h-how-to-connect-to-multiple-sources-in-power-bi\"><span style=\"font-weight: 400;\">How to Connect to Multiple Sources in Power BI<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Now let\u2019s get to the core part of the article: how exactly do you connect all these different sources in Power BI? Let me guide you through this, step by step.<\/span><\/p>\n<ol class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Open Power BI Desktop<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Click <\/span><b>\u201cGet Data\u201d<\/b><span style=\"font-weight: 400;\"> from the Home ribbon.<\/span><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"873\" height=\"363\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-2-1.webp\" alt=\"How to Connect to Multiple Data Sources in Power BI | Step 2\" class=\"wp-image-237132\" style=\"width:740px;height:auto\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-2-1.webp 873w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-2-1-300x125.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-2-1-768x319.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-2-1-150x62.webp 150w\" sizes=\"auto, (max-width: 873px) 100vw, 873px\"\/><\/figure>\n<ol start=\"3\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Choose your first source, say, \u201c<\/span><b>Excel Workbook\u201d<\/b><span style=\"font-weight: 400;\"> and click on <\/span><b>\u201cConnect\u201d<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"717\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-3-1.webp\" alt=\"How to Connect to Multiple Data Sources in Power BI | Step 3\" class=\"wp-image-237133\" style=\"width:747px;height:auto\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-3-1.webp 739w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-3-1-300x291.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-3-1-150x146.webp 150w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\"\/><\/figure>\n<ol start=\"4\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Navigate to the Excel file, and open it.<\/span><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"546\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-4-1.webp\" alt=\"How to Connect to Multiple Data Sources in Power BI | Step 4\" class=\"wp-image-237134\" style=\"width:699px;height:auto\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-4-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-4-1-300x188.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-4-1-768x481.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-4-1-150x94.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<ol start=\"5\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Now, in the Navigator, select the files you need to import into Power BI and load the data you need. You can transform it in Power Query by clicking on <\/span><b>\u201cTransform Data\u201d<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"702\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-5-1.webp\" alt=\"How to Connect to Multiple Data Sources in Power BI | Step 5\" class=\"wp-image-237135\" style=\"width:681px;height:auto\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-5-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-5-1-300x242.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-5-1-768x618.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-5-1-150x121.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<ol start=\"6\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Now your data will load into Power BI.<\/span><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"845\" height=\"312\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-6-1.webp\" alt=\"How to Connect to Multiple Data Sources in Power BI | Step 6\" class=\"wp-image-237136\" style=\"width:694px;height:auto\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-6-1.webp 845w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-6-1-300x111.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-6-1-768x284.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-6-1-150x55.webp 150w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\"\/><\/figure>\n<ol start=\"7\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Next, click on <\/span><b>\u201cGet Data\u201d<\/b><span style=\"font-weight: 400;\"> again. This time, maybe choose <\/span><b>Web.<\/b><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"584\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-7-1.webp\" alt=\"How to Connect to Multiple Data Sources in Power BI | Step 7\" class=\"wp-image-237137\" style=\"width:682px;height:auto\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-7-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-7-1-300x201.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-7-1-768x514.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-7-1-150x100.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<ol start=\"8\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Paste a URL with some public data (e.g., Results table on the UEFA European Football Championship Wikipedia page at: <\/span><a href=\"https:\/\/en.wikipedia.org\/wiki\/UEFA_European_Football_Championship\" target=\"_blank\" rel=\"noreferrer noopener nofollow\"><span style=\"font-weight: 400;\">https:\/\/en.wikipedia.org\/wiki\/UEFA_European_Football_Championship<\/span><\/a><span style=\"font-weight: 400;\">)<\/span><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"286\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-8-1.webp\" alt=\"How to Connect to Multiple Data Sources in Power BI | Step 8\" class=\"wp-image-237138\" style=\"width:669px;height:auto\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-8-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-8-1-300x98.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-8-1-768x252.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-8-1-150x49.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<ol start=\"9\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">After the data loads in the Navigator, select the sheet or table you need and <\/span><b>Load<\/b><span style=\"font-weight: 400;\"> into Power BI. If required, you can also <\/span><b>Transform<\/b><span style=\"font-weight: 400;\"> the <\/span><b>Data<\/b><span style=\"font-weight: 400;\">.<\/span><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"706\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-9-1-1.webp\" alt=\"How to Connect to Multiple Data Sources in Power BI | Step 9\" class=\"wp-image-237139\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-9-1-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-9-1-1-300x243.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-9-1-1-768x622.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-9-1-1-150x121.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<ol start=\"10\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Keep repeating as needed. Each source you connect to becomes a new table in your model.<\/span><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"447\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-10-1.webp\" alt=\"How to Connect to Multiple Data Sources in Power BI | Step 10\" class=\"wp-image-237140\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-10-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-10-1-300x154.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-10-1-768x394.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-10-1-150x77.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<h3 class=\"wp-block-heading\" id=\"h-types-of-connection-modes-in-power-bi\">Types of Connection Modes in Power BI<\/h3>\n<p>When you connect to data in Power BI, you\u2019re given a choice between two major connection modes: <b>Import <\/b><span style=\"font-weight: 400;\">(which we used previously)<\/span> and <strong>DirectQuery<\/strong>. Each mode has its own strengths and trade-offs, and understanding them is crucial for building efficient, responsive dashboards.<\/p>\n<h4 class=\"wp-block-heading\" id=\"h-1-import-mode\">1. <strong>Import Mode<\/strong><\/h4>\n<p>This is the most commonly used and recommended connection mode for most scenarios. In this method, Power BI pulls the data from your source and stores it <em>locally<\/em> within the .pbix file. It works best when data doesn\u2019t change frequently or when high performance and full modeling capabilities are required.<\/p>\n<p><strong>Advantages:<\/strong><\/p>\n<ul class=\"wp-block-list\">\n<li><strong>High performance:<\/strong> Since the data is loaded into Power BI\u2019s in-memory engine, reports are fast and highly responsive.<\/li>\n<li><strong>Rich features:<\/strong> You can take full advantage of DAX, complex data transformations, calculated columns, and custom measures.<\/li>\n<li><strong>Offline access:<\/strong> Once imported, the data can be analyzed even without a live connection to the data source.<\/li>\n<\/ul>\n<p><strong>Disadvantages:<\/strong><\/p>\n<ul class=\"wp-block-list\">\n<li><strong>Data freshness:<\/strong> Since the data is static until refreshed, your report can become outdated unless you schedule regular refreshes.<\/li>\n<li><strong>File size limits:<\/strong> Very large datasets may increase the .pbix file size and lead to performance issues if not optimized.<\/li>\n<\/ul>\n<h4 class=\"wp-block-heading\">2. <strong>DirectQuery Mode<\/strong><\/h4>\n<p>In DirectQuery mode, Power BI does <em>not<\/em> store the data. Instead, it sends queries to the source every time you interact with the report. The data remains in the source system, and Power BI fetches only what\u2019s needed, as and when required. It is the better choice in scenarios where real-time or near-real-time data is essential. Make sure that when you use it, the underlying data source can handle frequent query loads efficiently.<\/p>\n<p><strong>Advantages:<\/strong><\/p>\n<ul class=\"wp-block-list\">\n<li><strong>Real-time access:<\/strong> You always see the latest data, which is ideal for operational or monitoring dashboards.<\/li>\n<li><strong>No size limits:<\/strong> Since the data isn\u2019t stored in the report file, there\u2019s no concern about hitting memory or file size limits.<\/li>\n<\/ul>\n<p><strong>Disadvantages:<\/strong><\/p>\n<ul class=\"wp-block-list\">\n<li><strong>Slower performance:<\/strong> Every click or interaction sends a query to the source, which can lead to delays depending on the source\u2019s speed and workload.<\/li>\n<li><strong>Limited functionality:<\/strong> Some Power BI features (like certain DAX functions, data transformations, and calculated tables) are restricted or unavailable.<\/li>\n<li><strong>Dependency on source availability:<\/strong> If your source goes down, your report breaks or loads slowly.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\" id=\"h-popular-real-world-data-sources-to-try-out\"><span style=\"font-weight: 400;\">Popular Real-World Data Sources to Try Out<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">If you\u2019re trying this out or writing a tutorial (like I\u2019m doing here), it\u2019s best to use data sources that are free and easy to access. Here are my favourite picks:<\/span><\/p>\n<div class=\"table-responsive mb-3\">\n<table class=\"table table-hover table-bordered\">\n<thead\/>\n<tbody>\n<tr>\n<td><b>Source<\/b><\/td>\n<td><b>Why It\u2019s Useful<\/b><\/td>\n<\/tr>\n<tr>\n<td><strong>Excel \/ CSV<\/strong><\/td>\n<td><span style=\"font-weight: 400;\">Easy to create mock data<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong>Web Page \/ API<\/strong><\/td>\n<td><span style=\"font-weight: 400;\">Fetches live data like exchange rates or weather<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong>OData Feed<\/strong><\/td>\n<td><span style=\"font-weight: 400;\">Microsoft provides public OData feeds (Northwind)<\/span><\/td>\n<\/tr>\n<tr>\n<td><strong>Local SQL Server<\/strong><\/td>\n<td><span style=\"font-weight: 400;\">Provides data in a database-style structure<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400;\">With all of these free options available, you can skip sources like Salesforce or Azure, unless you\u2019re already paying for those platforms.<\/span><\/p>\n<h2 class=\"wp-block-heading\" id=\"h-combining-data-from-multiple-sources-in-power-bi\"><span style=\"font-weight: 400;\">Combining Data from Multiple Sources in Power BI<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">So now you\u2019ve got all these sources in your report, but how do you make them work together?<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This is where <\/span><b>Power Query<\/b><span style=\"font-weight: 400;\"> and the <\/span><b>Model View<\/b><span style=\"font-weight: 400;\"> come into play.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In Power Query, you can:<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><b>Transform<\/b><span style=\"font-weight: 400;\"> each dataset, rename columns, filter rows, and change data types<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Use <\/span><b>Append<\/b><span style=\"font-weight: 400;\"> if tables are similar (stack rows)<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Use <\/span><b>Merge<\/b><span style=\"font-weight: 400;\"> if you want to join tables by a key (like a <a href=\"https:\/\/www.analyticsvidhya.com\/blog\/2023\/06\/vlookup-in-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">VLOOKUP<\/a>)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">In Model View, you can:<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Define <\/span><b>relationships<\/b><span style=\"font-weight: 400;\"> between tables (e.g., Orders table links to Products table)<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Always check for <\/span><b>one-to-many<\/b><span style=\"font-weight: 400;\"> or <\/span><b>many-to-many<\/b><span style=\"font-weight: 400;\"> issues<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Don\u2019t create circular references, Power BI doesn\u2019t like those<\/span><\/li>\n<\/ul>\n<h3 class=\"wp-block-heading\" id=\"h-performance-and-refresh-considerations\"><span style=\"font-weight: 400;\">Performance and Refresh Considerations<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">You need to be careful when mixing data sources, especially when some of them are from the cloud and some are local. Here are a few things to keep in mind:<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><b>Import mode<\/b><span style=\"font-weight: 400;\"> = fastest way to get the data and supports all Power BI features.<\/span><\/li>\n<li><b>DirectQuery<\/b><span style=\"font-weight: 400;\"> = stays updated but slower, with limited transformations.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Some sources don\u2019t refresh automatically, you\u2019ll need a <\/span><b>Gateway\u00a0<\/b>for them<span style=\"font-weight: 400;\"> (especially for on-prem SQL).<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Scheduled refresh might fail if credentials aren\u2019t set up correctly.<\/span><\/li>\n<\/ul>\n<p><b><i>Pro Tip:<\/i><\/b><i><span style=\"font-weight: 400;\"> If possible, keep all your data in the same mode (either all Import or all DirectQuery) to avoid compatibility headaches.<\/span><\/i><\/p>\n<h3 class=\"wp-block-heading\" id=\"h-use-case-example\"><span style=\"font-weight: 400;\">Use Case Example<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Let\u2019s say you want to make a dashboard showing:<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><b>Monthly budget<\/b><span style=\"font-weight: 400;\">: from a CSV file<\/span><\/li>\n<li><b>Actual sales<\/b><span style=\"font-weight: 400;\">: from a SQL Server table (on-premises)<\/span><\/li>\n<li><b>Exchange rates<\/b><span style=\"font-weight: 400;\">: from a public API (like exchangerate-api.com)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Here\u2019s how you can do it:<\/span><\/p>\n<ol class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Connect to Test\/CSV<\/span><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"816\" height=\"657\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-11-1.webp\" alt=\"\" class=\"wp-image-237142\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-11-1.webp 816w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-11-1-300x242.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-11-1-768x618.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-11-1-150x121.webp 150w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\"\/><\/figure>\n<ol start=\"2\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Load the budget table. I\u2019m using a sample table here, feel free to load your own dataset<\/span>.<\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"572\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-12-1.webp\" alt=\"\" class=\"wp-image-237143\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-12-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-12-1-300x197.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-12-1-768x504.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-12-1-150x98.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<ol start=\"3\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Connect to SQL Server<\/span>.<\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"852\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-13-1.webp\" alt=\"\" class=\"wp-image-237144\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-13-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-13-1-300x293.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-13-1-768x750.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-13-1-150x147.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<ol start=\"4\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Load sales by region data (or any other data of your choice). <\/span><span style=\"font-weight: 400;\">In the SQL Server database dialog box, enter the Server and Database (optional) names, and make sure the Data Connectivity mode is set to Import.<\/span><\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"438\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-14-1.webp\" alt=\"\" class=\"wp-image-237145\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-14-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-14-1-300x151.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-14-1-768x386.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-14-1-150x75.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<ol start=\"5\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Select OK, and on the next screen, verify your credentials, and then select Connect.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Select the required tables and Load the data.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Use <\/span><b>Get Data &gt; Web<\/b><span style=\"font-weight: 400;\"> to pull exchange rates (https:\/\/app.exchangerate-api.com)<\/span>.<\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"276\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-15-1.webp\" alt=\"\" class=\"wp-image-237146\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-15-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-15-1-300x95.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-15-1-768x243.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-15-1-150x47.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<ol start=\"8\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">In Power Query, transform and format all tables<\/span>.<\/li>\n<\/ol>\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"872\" height=\"460\" src=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-16-1.webp\" alt=\"\" class=\"wp-image-237147\" srcset=\"https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-16-1.webp 872w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-16-1-300x158.webp 300w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-16-1-768x405.webp 768w, https:\/\/cdn.analyticsvidhya.com\/wp-content\/uploads\/2025\/06\/Power-BI-16-1-150x79.webp 150w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\"\/><\/figure>\n<ol start=\"9\" class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Merge the exchange rate with sales to convert values<\/span>.<\/li>\n<li><span style=\"font-weight: 400;\">Create visuals (bar charts, KPIs, maps)<\/span>.<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Boom, now you have a report that communicates with data from 3 very different sources.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Just remember:<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><span style=\"font-weight: 400;\">Use <\/span><b>Import mode<\/b><span style=\"font-weight: 400;\"> unless you need live data.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Combine data carefully, clean it first, then relate or join as required.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Don\u2019t go crazy mixing every source possible. Start small and grow as needed.<\/span><\/li>\n<li>If you\u2019re new, try with <b>Excel + OData + Web API<\/b>, all free and easy to use.<\/li>\n<\/ul>\n<h3 class=\"wp-block-heading\" id=\"h-important-note-for-sql-server-data-on-premises\"><span style=\"font-weight: 400;\">Important Note for SQL Server Data (On-Premises)<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">For your SQL Server data, since it\u2019s an on-premises source, you\u2019ll need to set up a Power BI On-premises Data Gateway. Think of this gateway as a secure bridge that allows Power BI (which operates in the cloud) to safely connect to your local <a href=\"https:\/\/www.analyticsvidhya.com\/blog\/2021\/06\/sql-for-data-science-a-beginners-guide\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server database<\/a>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Once the gateway is configured, you can schedule automatic data refreshes for your report. This means your dashboard will stay up-to-date with the latest sales figures without you having to manually refresh the data in Power BI Desktop. You can set the refresh frequency (e.g., daily, hourly) directly within the Power BI Service.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Without the gateway, Power BI wouldn\u2019t be able to reach your local SQL Server, and you\u2019d be stuck manually importing the sales data each time you wanted to update your report.<\/span><\/p>\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\"><span style=\"font-weight: 400;\">Conclusion<\/span><\/h2>\n<p>Connecting to multiple data sources in Power BI isn\u2019t just possible \u2013 it\u2019s one of the platform\u2019s strongest capabilities.\u00a0Power BI makes it super simple (and powerful) to pull data from local Excel files, cloud platforms, SQL databases, live APIs \u2013 you name it.\u00a0It gives you the flexibility to blend all of this data into a single, unified, insightful report. However, the key to success lies in managing your data relationships, choosing the right connection modes, and planning for refresh needs. With a little practice, you\u2019ll be building powerful, multi-source dashboards that tell the complete story, without breaking a sweat.<\/p>\n<\/p><\/div>\n<p><h4 class=\"fs-24 text-dark\">Login to continue reading and enjoy expert-curated content.<\/h4>\n<p>                        <button class=\"btn btn-primary mx-auto d-table\" data-bs-toggle=\"modal\" data-bs-target=\"#loginModal\" id=\"readMoreBtn\">Keep Reading for Free<\/button>\n                    <\/p>\n<p>                    <!-- Free Courses --><\/p><\/div>\n<p>                                  <!-- Right Side Bar Reading list  -->\n                                              <\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>You have Power BI on your system, and you wonder, \u201cCan I actually fetch data from more than one source?\u201d Like maybe six different sources, or some Excel files, with an SQL database, or even pull in some live exchange rates from the web? Let me answer that in short \u2013 yes, you totally can. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":288189,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12033],"tags":[16723,11603,1025,1783,27699],"dealstore":[],"offerexpiration":[],"class_list":["post-288188","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","tag-connect","tag-data","tag-multiple","tag-power","tag-sources"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Connect to Multiple Data Sources in Power BI? - Som2ny Network<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fivemor.com\/?p=288188\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect to Multiple Data Sources in Power BI? - Som2ny Network\" \/>\n<meta property=\"og:description\" content=\"You have Power BI on your system, and you wonder, \u201cCan I actually fetch data from more than one source?\u201d Like maybe six different sources, or some Excel files, with an SQL database, or even pull in some live exchange rates from the web? Let me answer that in short \u2013 yes, you totally can. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fivemor.com\/?p=288188\" \/>\n<meta property=\"og:site_name\" content=\"Som2ny Network\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-11T14:54:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/06\/Power-BI-cover.webp.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"872\" \/>\n\t<meta property=\"og:image:height\" content=\"473\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fivemor.com\/?p=288188#article\",\"isPartOf\":{\"@id\":\"https:\/\/fivemor.com\/?p=288188\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371\"},\"headline\":\"How to Connect to Multiple Data Sources in Power BI?\",\"datePublished\":\"2025-06-11T14:54:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fivemor.com\/?p=288188\"},\"wordCount\":1743,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fivemor.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/?p=288188#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/06\/Power-BI-cover.webp.webp\",\"keywords\":[\"Connect\",\"Data\",\"Multiple\",\"Power\",\"sources\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fivemor.com\/?p=288188#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fivemor.com\/?p=288188\",\"url\":\"https:\/\/fivemor.com\/?p=288188\",\"name\":\"How to Connect to Multiple Data Sources in Power BI? - Som2ny Network\",\"isPartOf\":{\"@id\":\"https:\/\/fivemor.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fivemor.com\/?p=288188#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/?p=288188#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/06\/Power-BI-cover.webp.webp\",\"datePublished\":\"2025-06-11T14:54:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fivemor.com\/?p=288188#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fivemor.com\/?p=288188\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/?p=288188#primaryimage\",\"url\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/06\/Power-BI-cover.webp.webp\",\"contentUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/06\/Power-BI-cover.webp.webp\",\"width\":872,\"height\":473},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fivemor.com\/?p=288188#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/fivemor.com\/?bp_activities=1\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Connect to Multiple Data Sources in Power BI?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fivemor.com\/#website\",\"url\":\"https:\/\/fivemor.com\/\",\"name\":\"Som2ny Network\",\"description\":\"Daily Deals\",\"publisher\":{\"@id\":\"https:\/\/fivemor.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fivemor.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/fivemor.com\/#organization\",\"name\":\"Som2ny Network\",\"url\":\"https:\/\/fivemor.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png\",\"contentUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png\",\"width\":300,\"height\":86,\"caption\":\"Som2ny Network\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/fivemor.com\"],\"url\":\"https:\/\/fivemor.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Connect to Multiple Data Sources in Power BI? - Som2ny Network","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fivemor.com\/?p=288188","og_locale":"en_US","og_type":"article","og_title":"How to Connect to Multiple Data Sources in Power BI? - Som2ny Network","og_description":"You have Power BI on your system, and you wonder, \u201cCan I actually fetch data from more than one source?\u201d Like maybe six different sources, or some Excel files, with an SQL database, or even pull in some live exchange rates from the web? Let me answer that in short \u2013 yes, you totally can. [&hellip;]","og_url":"https:\/\/fivemor.com\/?p=288188","og_site_name":"Som2ny Network","article_published_time":"2025-06-11T14:54:06+00:00","og_image":[{"width":872,"height":473,"url":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/06\/Power-BI-cover.webp.webp","type":"image\/webp"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fivemor.com\/?p=288188#article","isPartOf":{"@id":"https:\/\/fivemor.com\/?p=288188"},"author":{"name":"admin","@id":"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371"},"headline":"How to Connect to Multiple Data Sources in Power BI?","datePublished":"2025-06-11T14:54:06+00:00","mainEntityOfPage":{"@id":"https:\/\/fivemor.com\/?p=288188"},"wordCount":1743,"commentCount":0,"publisher":{"@id":"https:\/\/fivemor.com\/#organization"},"image":{"@id":"https:\/\/fivemor.com\/?p=288188#primaryimage"},"thumbnailUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/06\/Power-BI-cover.webp.webp","keywords":["Connect","Data","Multiple","Power","sources"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fivemor.com\/?p=288188#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fivemor.com\/?p=288188","url":"https:\/\/fivemor.com\/?p=288188","name":"How to Connect to Multiple Data Sources in Power BI? - Som2ny Network","isPartOf":{"@id":"https:\/\/fivemor.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fivemor.com\/?p=288188#primaryimage"},"image":{"@id":"https:\/\/fivemor.com\/?p=288188#primaryimage"},"thumbnailUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/06\/Power-BI-cover.webp.webp","datePublished":"2025-06-11T14:54:06+00:00","breadcrumb":{"@id":"https:\/\/fivemor.com\/?p=288188#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fivemor.com\/?p=288188"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/?p=288188#primaryimage","url":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/06\/Power-BI-cover.webp.webp","contentUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/06\/Power-BI-cover.webp.webp","width":872,"height":473},{"@type":"BreadcrumbList","@id":"https:\/\/fivemor.com\/?p=288188#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fivemor.com\/?bp_activities=1"},{"@type":"ListItem","position":2,"name":"How to Connect to Multiple Data Sources in Power BI?"}]},{"@type":"WebSite","@id":"https:\/\/fivemor.com\/#website","url":"https:\/\/fivemor.com\/","name":"Som2ny Network","description":"Daily Deals","publisher":{"@id":"https:\/\/fivemor.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fivemor.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/fivemor.com\/#organization","name":"Som2ny Network","url":"https:\/\/fivemor.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/#\/schema\/logo\/image\/","url":"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png","contentUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png","width":300,"height":86,"caption":"Som2ny Network"},"image":{"@id":"https:\/\/fivemor.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png","caption":"admin"},"sameAs":["https:\/\/fivemor.com"],"url":"https:\/\/fivemor.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts\/288188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=288188"}],"version-history":[{"count":0,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts\/288188\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/media\/288189"}],"wp:attachment":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=288188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=288188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=288188"},{"taxonomy":"dealstore","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fdealstore&post=288188"},{"taxonomy":"offerexpiration","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fofferexpiration&post=288188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}