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 Tutorial	SQL Advance Tutorial	SSRS	Interview Q & A
SQL Create table	SQL Server Stored Procedure	Create a New SSRS Project	List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLE	SQL Server Merge	Create a Shared Data Source in SSRS	SQL Server Question & Answer Quiz
SQL Drop	SQL Server Pivot	Create a SSRS Tabular Report / Detail Report
..... More	.... More	....More
Power BI Tutorial	Azure Tutorial	Python Tutorial	SQL Server Tips & Tricks
Download and Install Power BI Desktop	Create an Azure storage account	Learn Python & ML Step by step	Enable Dark theme in SQL Server Management studio
Connect Power BI to SQL Server	Upload files to Azure storage container		SQL Server Template Explorer
Create Report ToolTip Pages in Power BI	Create Azure SQL Database Server		Displaying line numbers in Query Editor Window
....More	....More		....More

 5,766 total views,  1 views today