Load data from multiple data sources into Power BI - In real time, you might face a situation where the data is present in different databases. However, you don't have to worry in these situations because Power BI supports multiple data sources on one chart. Let me show you the step-by-step approach to fetching or loading data from multiple data sources into Power BI.
How to load data from multiple data sources into Power BI
In the following screenshot, you can see that there are already some tables inside the Power Bi desktop. We imported these tables in the Connect to SQL article.
<>If you are on the Power BI visualization page, on the Home tab, click the Get information option and select the Server SQL, as we show below. Or select More and select the SQL Server option.
Here you need to provide the name of the SQL Server instance. If you installed SQL with the default instance, then the instance name is the computer name or localhost or .
Let me use the local instance and click OK
In the display options, it lists the databases that are available for that instance. In this example, we are selecting three tables present in the Employees database.
Now you can see the tables we selected.
Let me create a table with the fields from the Employee database and the fields from the Adventure Works DW database.
As you can see in the following screenshot, we also formatted the Table.
NOTE: I suggest that you refer to the Create a table and Format a table articles to understand the table creation and formatting options.
