Getting Data into Power BI from Different Sources

Getting Data into Power BI from Different Sources looks at connecting to data sources on-premise, in the Azure cloud, and Power platform data sources. The course is focused on how various data sources can impact your data model's performance, rather than looking at every single source that Power BI accommodates, as there are literally dozens and dozens of them. Apart from typical database and file data sources we look at Dataverse, a power platform repository and data flow an online ETL service.

Learning Objectives

  • How to connect to a database and file data source on-premises and in the Azure cloud
  • How to change the location of a data source without reimporting the data
  • Look at the pros and cons of each Power BI data storage mode
  • User Power Platform's Dataverse product as a data source
  • How to and why you would use a Data Flow as a data source
  • Setting up and connecting to an XMLA endpoint

Intended Audience

  • This course is intended for anyone who wants to get data into Power BI


  • An understanding of Power BI desktop and power BI online
  • A Power BI premium account for XMLA endpoint, one of the more specialized data connection topics



Hi, and welcome to this Getting Data into Power BI from different sources course. My name is Hallam Webber, and I'm an Azure instructor with 25-plus years of experience in the IT industry, and since 2014 I've focused on Microsoft Azure and related technologies.

This course is aimed at students wanting to learn how to get data from various types of sources located on different platforms into Power Bi. 

The information presented in this course will be helpful to students preparing for the PL-300: Microsoft Power Bi Data Analyst exam.

In this course, we’ll see how to pull data from databases and files hosted locally and in Azure. As we shall see, Power Bi supports many data sources, literally dozens and dozens. So, we will not be looking at all of the data sources because that would make for a very long and slightly boring course. We’ll look at Power BI’s different storage modes and how those modes impact performance.

This is an intermediate-level course, so I expect you to have used Power Bi desktop and Power Bi online before. XMLA endpoint, one of the more specialized data connection topics, does require a premium or premium per-user account. You can sign up for a premium account on a generous trial basis.

When I created this course, all information was current. If you have any feedback, positive or negative, or if you notice anything that needs to be updated or corrected, please reach out to us at

About the Author
Learning Paths

Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a  Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.