与同事共享筛选的 Power BI 报表Share a filtered Power BI report with your coworkers

共享是一种使多人能够访问你的仪表板和报表的有效方式。Sharing is a good way to give a few people access to your dashboards and reports. Power BI 还提供了其他多种开展协作和分发报表的方式Power BI also offers several other ways to collaborate and distribute your reports.

要进行共享,你和收件人都需要一个 Power BI Pro 许可证,或者内容需要位于高级容量中。With sharing, you and your recipients need a Power BI Pro license, or the content needs to be in a Premium capacity. 建议?Suggestions? Power BI 团队始终期待你的反馈,因此,请转到 Power BI 社区站点The Power BI team is always interested in your feedback, so go to the Power BI Community site.

可以在同一电子邮件域中与同事共享报表(与在 Power BI 服务中的大多数位置一样):收藏夹、最近浏览、与我共享(如果所有者允许该操作)、我的工作区或其他工作区。You can share a report with coworkers in the same email domain as you, from most places in the Power BI service: your Favorites, Recent, Shared with me (if the owner allows it), My Workspace, or other workspaces. 共享报表时,你与之共享的人员可查看该报表并与其交互,但不能编辑它。When you share a report, those you share it with can view it and interact with it, but can't edit it. 除非应用行级别安全性 (RLS),否则他们会看到你在报表中看到的相同数据。They see the same data that you see in the report, unless row-level security (RLS) is applied.

筛选和共享报表Filter and share a report

如果你想要共享筛选的报表版本,该怎么办?What if you want to share a filtered version of a report? 也许一个报表仅显示特定城市或销售人员或年份的数据。Maybe a report that only shows data for a specific city or salesperson or year. 可以通过创建自定义 URL 来执行此操作。You do this by creating a custom URL.

  1. 打开编辑视图中的报表、应用筛选器并保存报表。Open the report in Editing view, apply the filter, and save the report.

    在此示例中,我们正在筛选零售分析示例,从而仅显示“区域”等于“NC”的值。In this example we're filtering the Retail Analysis sample to show only values where Territory equals NC.

    报表筛选窗格

  2. 将以下代码添加到以下报表页 URL 的末尾:Add the following to the end of the report page URL:

    ?filter=tablename/fieldname eq value?filter=tablename/fieldname eq value

    此字段必须是字符串类型,并且表名或字段名都不可以包含空格。The field must be of type string and neither tablename or fieldname can contain spaces.

    在本示例中,表的名称是 Store,字段的名称是 Territory,我们要筛选的依据值是 NCIn our example, the name of the table is Store, the name of the field is Territory, and the value we want to filter on is NC:

    ?filter=Store/Territory eq 'NC'?filter=Store/Territory eq 'NC'

    已筛选的报表 URL

    浏览器会添加特殊字符来表示斜杠、空格和撇号,因此最终会看到:Your browser adds special characters to represent slashes, spaces, and apostrophes, so you end up with:

    app.powerbi.com/groups/me/reports/010ae9ad-a9ab-4904-a7a1-xxxxxxxxxxxx/ReportSection2?filter=Store%252FTerritory%20eq%20%27NC%27app.powerbi.com/groups/me/reports/010ae9ad-a9ab-4904-a7a1-xxxxxxxxxxxx/ReportSection2?filter=Store%252FTerritory%20eq%20%27NC%27

  3. 共享报表,但清除向收件人发送电子邮件通知复选框。Share the report, but clear the Send email notificaton to recipients check box.

    共享报表对话框

  4. 使用前面创建的筛选器发送链接。Send the link with the filter that you created earlier.

后续步骤Next steps