将 CDM 文件夹添加到 Power BI 作为数据流(预览)Add a CDM folder to Power BI as a dataflow (Preview)

在 Power BI 中,可以添加存储在组织的 Azure Data Lake Store Gen2 中的 Common Data Model (CDM) 文件夹作为数据流。In Power BI, you can add Common Data Model (CDM) folders stored in your organization's Azure Data Lake Store Gen2 as dataflows. 从 CDM 文件夹创建数据流后,则可以基于置于 CDM 文件夹的数据使用 Power BI Desktop 和 Power BI 服务创建数据集、报表、仪表板和应用。 And once you create a dataflow from a CDM folder, you can use Power BI Desktop and the Power BI service to create datasets, reports, dashboards, and apps that are based on the data you put into CDM folders.

CDM 文件夹中的数据流

下面列出了从 CDM 文件夹创建数据流的几个要求:There are a few requirements for creating dataflows from CDM folders, as the following list describes:

以下部分介绍了如何从 CDM 文件夹创建数据流。The following sections describe how to create a dataflow from a CDM folder.

授权用户使用 CDM 文件夹创建数据流Authorizing users for CDM folders to create a dataflow

若要使用 CDM 文件夹创建数据流,必须添加以下权限:In order to create a dataflow from a CDM folder the following permissions must be added:

  • 将通过 Power BI 访问 CDM 文件夹的用户必须列在存储帐户的“存储 Blob 数据所有者”角色下 。The user that will be accessing the CDM folder through Power BI must be listed under the Storage Blob Data Owner role of the storage account.
  • 将通过 Power BI 访问 CDM 文件夹的用户必须对 CDM 文件夹本身及其中的任何文件或文件夹具有“读取访问”和“执行访问”ACL 。The user that will access the CDM folder through Power BI must have Read Access and Execute Access ACLs on both the CDM folder itself and any files or folders within it.

从 CDM 文件夹创建数据流Create a dataflow from a CDM folder

若要开始从 CDM 文件夹创建数据流,请启动“Power BI 服务”,然后从导航窗格中选择“工作区” 。To get started creating a dataflow from a CDM folder, launch the Power BI service and select a workspace from the nav pane. 也可以新建一个工作区,可用于创建新的工作流。You can also create a new workspace, in which you can create your new dataflow.

在 Power BI 服务中创建数据流

在显示的屏幕中,选择如下图所示的“创建并附加” 。In the screen that appears, select to Create and attach as shown in the following image.

创建并附加新数据流

接下来显示的屏幕可让你命名数据流,提供数据流的说明,并提供组织的 Azure Data Lake Gen2 帐户中的 CDM 文件夹的路径。The screen that appears next lets you name your dataflow, provide a description of the dataflow, and provide the path to the CDM folder in your organization's Azure Data Lake Gen2 account. 阅读本文中介绍如何获取 CDM 文件夹路径的部分。Read the section in the article that describes how to get your CDM folder path.

CDM 文件夹中的数据流

提供信息后,请选择“创建并附加” 以创建数据流。Once you've provided the information, select Create and attach to create the dataflow.

CDM 文件夹中的数据流显示在 Power BI 中时标有 “外部”图标。Dataflows from CDM folders are marked with external icon when displayed in Power BI. 在下一部分中,我们将介绍标准数据流与 CDM 文件夹中创建的数据流之间的差异。In the next section, we describe differences between standard dataflows, and dataflows created from CDM folders.

按本文前面所述正确设置权限后,可以在 Power BI Desktop 中连接到数据流 。Once permissions are properly set, as described previously in this article, you can connect to your dataflow in Power BI Desktop.

注意事项和限制Considerations and limitations

使用 CDM 文件夹中创建的数据流的权限时,该过程类似于 Power BI 中的外部数据源。When working with permissions to a dataflow created from a CDM folder, the process is similar to external datasources in Power BI. 权限在数据源中(而不是在 Power BI 中)进行管理。Permissions are managed at the data source, and not from within Power BI. 必须在数据源本身(例如 CDM 文件夹中创建的数据流)中正确设置权限,才能正确使用 Power BI。Permissions must be set appropriately on the data source itself, such as a dataflow created from a CDM folder, in order to work properly with Power BI.

以下列表可帮助说明如何使用 Power BI 运行 CDM 文件夹中的数据流。The following lists help clarify how dataflows from CDM folders operate with Power BI.

Power BI Pro、Premium 和 Embedded 工作区:Power BI Pro, Premium, and Embedded workspaces:

  • 无法编辑 CDM 文件夹中的数据流Dataflows from CDM folders can't be edited
  • 读取 CDM 文件夹中创建的数据流的权限由 CDM 文件夹的所有者(而不是 Power BI)管理Permissions to read a dataflow created from a CDM folder is managed by the owner of the CDM folder, and not by Power BI

Power BI Desktop:Power BI Desktop:

  • 只有同时有权访问创建数据流的工作区和 CDM 文件夹的用户,才能从 Power BI 数据流连接器访问它的数据Only users who are authorized to both the workspace in which the dataflow was created and the CDM folder can access its data from the Power BI Dataflows connector

下面还列出了一些其他注意事项:There are some additional considerations as well, described in the following list:

  • 从 CDM 文件夹创建数据流 仅适用于新的工作区体验Creating dataflows from CDM folders is only available in the new workspace experience
  • 链接实体不适用于 CDM 文件夹中创建的数据流Linked entities is not available for dataflows created from CDM folders

Power BI Desktop 客户无法访问存储在 Azure Data Lake Storage Gen2 帐户中的数据流,除非他们是数据流所有者,或已被显式授权访问数据流的 CDM 文件夹。Power BI Desktop customers can't access dataflows stored in Azure Data Lake Storage Gen2 account, unless they're the owner of the dataflow or they've been explicitly authorized to the dataflow's CDM folder. 请考虑以下情况:Consider the following situation:

  1. Anna 创建了一个新的工作区,并将其配置为存储 CDM 文件夹中的数据流。Anna creates a new workspace and configures it to store dataflows from a CDM folder.
  2. Ben 也是 Anna 所创建工作区的成员,他希望利用 Power BI Desktop 和数据流连接器从 Anna 创建的数据流获取数据。Ben, who is also a member of the workspace Anna created, wants to use Power BI Desktop and the dataflow connector to get data from the dataflow Anna created.
  3. Ben 看到了错误,因为他没有被添加为数据湖中数据流的 CDM 文件夹的授权用户。Ben receives an error because Ben wasn't added as an authorized user to the dataflow's CDM folder in the data lake.

尝试使用数据流时出错

要解决此问题,必须授予 Ben 对 CDM 文件夹及其文件的读取权限。To resolve this issue, Ben must be granted reader permissions to the CDM Folder and its files. 可以在本文中了解有关如何授予 CDM 文件夹访问权限的详细信息。You can learn more about how to grant access to the CDM Folder in this article.

后续步骤Next Steps

本文提供了有关如何配置数据流的工作区存储的指南。This article provided guidance on how to configure workspace storage for dataflows. 有关详细信息,请参阅以下文章:For additional information, take a look at the following articles:

有关数据流、CDM 和 Azure Data Lake Storage Gen2 的详细信息,请参阅以下文章:For more information about dataflows, CDM, and Azure Data Lake Storage Gen2, take a look at the following articles:

有关总体数据流的信息,请查看以下这些文章:For information about dataflows overall, check out these articles:

有关 Azure 存储的详细信息,可以阅读以下这些文章:For more information about Azure storage, you can read these articles:

有关通用数据模型的详细信息,可以阅读其概述文章:For more information about the Common Data Model, you can read its overview article:

也可以随时尝试通过 Power BI 社区提问And you can always try asking questions of the Power BI Community.