In real-time you might face a situation where data is present in different databases. However, you do not have to worry in these situations because Power BI support multiple data source in one chart. In this article, we will show you, step by step approach to get or load data from multiple data sources in Power BI.
How to load data from Multiple Data Sources in Power BI
From the below screenshot you can see that there are already few tables inside the Power Bi desktop. We imported these tables in Connect to SQL article.
If you are in the Power BI visualization page. Under the Home tab, Click the Get Data option and select the SQL Server as we shown below. Or, select More and select SQL Server option
Here you have to provide the SQL Server Instance name. If you installed SQL with default instance, then the instance name will be computer name, or localhost or .
Let me use the local instance, and click OK
Under the Display options, it will list out the Databases that are available for that Instance. In this example, We are selecting three tables present in Employees database.
Now you can see the Tables that we selected.
Let me create a table with Employee Database fields, and Adventure Works DW database fields.
As you can see from the below screenshot, we also formatted the Table as well.