Skip to content
Home ยป Import Data from Multiple Data Source in Power BI

Import Data from Multiple Data Source in Power BI

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.

SQL Basics TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.