How to Connect Multiple Data Sources in Power BI

In this video we introduce working with multiple data sources in Power BI (in this example from Excel) and demonstrate how to connect each of these sources to form a larger dataset for reporting... best part is Power BI can do this automatically for you!

It is not essential, but a basic understanding of data hierarchy and relational databases would be beneficial.

Microsoft Power BI is a simple tool to master once you know your way around which offers functionality (such as formulas) that Excel users will already be familiar with. This tutorial will help you get started with downloading the application, an introduction to the user interface and how to import your first data set.

Please drop me a comment if you have any questions and find below links to complement this video!

Other Useful Links:

#powerbi #dashboards #database #datahierarchy #reporting

[EssentialExcel]

I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!

[sawankumar]

Very Helpful video. Do you have any video in which you have created any report with more than one data source.

[omkarsaval]

Thank you for the video, but how do we calculate measure when using multiple datasets like used in this video.

[junedshaikh]

in this example we had 1 spreadsheet and 3 tabs. Can we bring in multiple spreadsheets, provided we have a common factor in each excel file and try to link them?

[ahv]

Thanks for the video. I have two identical datasets: one is a historical data and saved as a csv file and the other one is from an API which gets refreshed everyday. I have built all my dashboards based on the API. Now if I follow your steps and append the historical one with the API one, does the data that’s coming from API in the appended table still gets updated or it overwrites the historical one as well? I need to keep the historical data fixed and refresh the API data daily.

[sia_ibk]

Really helpful tutorial. I noticed that from the excel sheet, the number of columns in the sales table was not equal to the others and you were able to still combine the data, how is this possible

[ateekain]

I have one cosmodb in India and another in singapore, both are same, because of data protection lwas have to keep two databses separate. now i want to run BI tools on these two DB simultaneously . Is it possible using POWER BI or Synapse to query two Azure cosmoDB together.