基于来自不同工作区的数据集创建报表Create reports based on datasets from different workspaces

了解如何根据其他工作区中的数据集在自己的工作区中创建报表。Learn how you can create reports in your own workspaces based on datasets in other workspaces. 要基于现有数据集生成报表,可从 Power BI Desktop 或 Power BI 服务的“我的工作区”或新的体验工作区中开始。To build a report on top of an existing dataset, you can start from Power BI Desktop or from the Power BI service, in your My Workspace or in a new workspace experience.

  • 在 Power BI 服务中:“获取数据” > “已发布数据集” 。In the Power BI service: Get data > Published datasets .

  • 在 Power BI Desktop 中:“获取数据” > “Power BI 数据集” 。In Power BI Desktop: Get data > Power BI datasets .

    连接到现有数据集

在这两种情况下,数据集发现体验都在此对话框中开始:“选择数据集以创建报表”。In both cases, the dataset discovery experience starts in this dialog box, Select a dataset to create a report . 可以看到你有权访问的所有数据集,无论它们位于何处:You see all the datasets you have access to, regardless of where they are:

选择一个数据集

你会注意到第一个数据集已标记为“已推广”。You notice the first one is labeled Promoted . 本文后面部分的查找已认可数据集中将对此进行介绍。We'll get to that in Find an endorsed dataset, later in this article.

你在此列表中看到的数据集至少满足以下条件之一:The datasets you see in this list meet at least one of the following conditions:

  • 数据集位于其中一个新的体验工作区,你是该工作区的成员。The dataset is in one of the new workspace experience workspaces, and you're a member of that workspace. 请参阅注意事项和限制See Considerations and limitations.
  • 你对位于新的体验工作区中的数据集具有“生成”权限。You have Build permission for the dataset, which is in a new workspace experience workspace.
  • 该数据集位于“我的工作区”中。The dataset is in your My Workspace.

备注

如果你是免费用户,则只能看到“我的工作区”中的数据集,或者“高级容量”工作区中你对其具有“生成”权限的数据集。If you're a free user, you only see datasets in your My Workspace, or datasets for which you have Build permission that are in Premium-capacity workspaces.

单击“创建”时,将创建与该数据集的实时连接,并可以使用完整的可用数据集打开报表创建体验。When you click Create , you create a live connection to the dataset, and the report creation experience opens with the full dataset available. 尚未创建数据集的副本。You haven't made a copy of the dataset. 数据集仍位于其原始位置。The dataset still resides in its original location. 可以使用数据集中的所有表和度量值来生成自己的报表。You can use all tables and measures in the dataset to build your own reports. 数据集上应用了行级别安全性 (RLS) 限制,因此你只能根据 RLS 角色查看有权查看的数据。Row-level security (RLS) restrictions on the dataset are in effect, so you only see data you have permissions to see based on your RLS role.

可以将报表保存到 Power BI 服务中的当前工作区,或者从 Power BI Desktop 将报表发布到工作区。You can save the report to the current workspace in the Power BI service, or publish the report to a workspace from Power BI Desktop. 如果报表基于工作区外的数据集,Power BI 会自动在数据集列表中创建一个条目。Power BI automatically creates an entry in the list of datasets if the report is based on a dataset outside of the workspace. 此数据集的图标与工作区中数据集的图标不同:The icon for this dataset is different from the icon for datasets in the workspace: 共享数据集图标

这样,工作区的成员可以区分哪些报表和仪表板使用工作区外的数据集。That way, members of the workspace can tell which reports and dashboards use datasets that are outside the workspace. 该条目显示有关数据集的信息以及一些选择操作。The entry shows information about the dataset, and a few select actions.

数据集操作

查找已认可数据集Find an endorsed dataset

有两种不同类型的已认可数据集。There are two different kinds of endorsed datasets. 数据集所有者可以推广他们向你推荐的数据集。Dataset owners can promote a dataset that they recommend to you. 此外,Power BI 管理员可以指定组织中的专家,他们可以验证数据集供所有人使用。Also, the Power BI admin can designate experts in your organization who can certify datasets for everyone to use. 查找数据集时可看到已推广和已验证数据集显示的徽章,这些徽章显示在工作区的数据集列表中。Promoted and certified datasets both display badges that you see both when looking for a dataset, and in the list of datasets in a workspace. 在数据集发现体验期间,验证数据集的人员的名称显示在工具提示中;将鼠标悬停在“认证”标签上将看到它。The name of the person who certified a dataset is displayed in a tooltip during the dataset discovery experience; hover over the Certified label and you see it.

  • 在 Power BI 服务中:“获取数据” > “已发布数据集” 。In the Power BI service: Get data > Published datasets .

  • 在 Power BI Desktop 中:“获取数据” > “Power BI 数据集” 。In Power BI Desktop: Get data > Power BI datasets .

    在“选择数据集”对话框中,默认情况下,已认可的数据集位于列表顶部。In the Select a dataset dialog box, endorsed datasets top the list by default.

    已推广的数据集

后续步骤Next steps