Import Data from Multiple Data Source in Power BI
Somtimes, you have a requirment to load data from multiple data sources where your data exists in different different databases. Definitely, it may take you a long time, when you go and import data one by one. Anyway in Power Bi you can data from multiple data sources in one go.
Following are the step that you can use to load data from multiple databases in Power Bi.
Go to Power Bi Ribbon , Click on Home Button > Next click on GetData.
After that Select SQL Server.
Once you click on SQL Server, a SQL Server Database window opens, Here you have to provide the SQL Server Instance name, Leave Database field as it is blank, If you provide database name then you will be able to see only that specific database’s tables only, and can not load other database’s table to Power Bi.
Next select Data connectivity mode.
Next click on OK Button
After that a Navigator window opens, which display the lists of available databases for the SQL Server instance.
Next, you can select any table from any database that you want to load in Power BI.
Lets first select the table HumanResourcesVEmployee from AdventureWorks2017 Database.
Do not click on LOAD button until you select all the required table that you want to load in Power BI.
Now we select the few more tables Department, Dept_Log, Emp_trgt, and Employee_Info from database SQLServerTutorial
In screenshot you can see only two tables Department and Dept_log that is selected , remaing table is not showing on screenshot due to long list of tables in database.
Now once you select required tables then finally click on Load button to finish the final step.
You can see, once you click on Load button, a Load window opens indicating table’s loading status.
Once it is done, You can see all the tables in Fields pane.
You can also verify whether table is loaded sucessfully by draging the table fields into visuals.
Lets create a table visual, drag employee_info table’s fields to table visuals.
You can see the the on table visuals.