Getting Data into Power BI from Different Sources

Focused View

Hallam Webber

45:34

19 View

1. Introduction.mp4

01:21

2. Overview.mp4

08:17

3. Change a Data Source Demo.mp4

09:46

4. Storage Mode Demo.mp4

09:03

5. Dataverse Demo.mp4

03:44

6. Data Flow Demo.mp4

06:00

7. XMLA Endpoints Demo.mp4

04:50

8. Summary.mp4

02:33

Description

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 lesson 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 lesson is intended for anyone who wants to get data into Power BI

Prerequisites

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

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Azure

Microsoft Power BI

Hallam Webber

Instructor's Courses

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.

Cloud Academy

View courses Cloud Academy

Join thousands of users in achieving your personal goals through Cloud Academy. Score job-ready tech skills that you can practice in a real environment, without the risk of extra costs or making mistakes. It’s simply the smartest way to gain certifications and get career-ready.