與同事共用已篩選的 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.

    在本例中,我們要篩選零售分析範例,只顯示 Territory 等於 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=<資料表名稱>/<檔案名稱> eq <值>?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