Cloud Academy – Getting Data into Power BI from Different Sources

将来自不同来源的数据导入 Power BI 着眼于连接到本地数据源、Azure 云中和 Power 平台数据源。本课程的重点是各种数据源如何影响数据模型的性能，而不是查看 Power BI 容纳的每一个源，因为实际上有几十个。除了典型的数据库和文件数据源，我们还关注 Dataverse，一个强大的平台存储库和数据流，一个在线 ETL 服务。

学习目标
如何连接到本地和 Azure 云中的数据库和文件数据源
如何在不重新导入数据的情况下更改数据源的位置
查看每种 Power BI 数据存储模式
的优缺点 User Power Platform 的 Dataverse产品作为数据源
如何以及为什么将数据流用作数据源
设置并连接到 XMLA 端点

目标受众
本课程面向希望将数据导入 Power BI 的任何人。

先决条件
了解 Power BI 桌面和在线
Power BI 用于 XMLA 端点的 Power BI 高级帐户，这是更专业的数据连接主题之一

MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz, 2 Ch
Difficulty: Intermediate | Genre: eLearning | Language: English + srt | Duration: 8 Lectures (46m) | Size: 1 GB

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.

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