共享链接到 OneDrive 中 Excel 文件的 Power BI 仪表板Share a Power BI dashboard that links to an Excel file in OneDrive

在 Power BI 中,你可以连接到 OneDrive for Business 上的 Excel 工作簿并将该工作簿中的磁贴固定到仪表板。In Power BI, you can connect to Excel workbooks on OneDrive for Business and pin tiles to a dashboard from that workbook. 共享该仪表板或创建包含该仪表板的内容包时:When you share that dashboard, or create a content pack that includes that dashboard:

  • 你的同事无需工作簿本身的权限即可查看磁贴。Your colleagues can view the tiles without needing permissions for the workbook itself. 因此你可以创建内容包,并了解你的同事可以看到从 OneDrive 上的 Excel 工作簿创建的磁贴。So you can create a content pack and know that your colleagues can see the tiles created from the Excel workbook on OneDrive.
  • 单击磁贴将在 Power BI 内打开该工作簿。Clicking the tile opens the workbook inside of Power BI. 仅当你的同事至少具有 OneDrive for Business 上工作簿的读取权限时,才会打开该工作簿。The workbook will only open if your colleagues have at least read permissions to the workbook on OneDrive for Business.

共享包含工作簿磁贴的仪表板Share a dashboard that contains workbook tiles

要共享链接回 OneDrive for Business 上的 Excel 工作簿的仪表板,请参阅共享仪表板To share a dashboard that links back to an Excel workbook on OneDrive for Business, see Share a dashboard. 不同之处在于,用户能够在共享之前选择修改链接的 Excel 工作簿的权限。The difference is that you have the option to modify the permissions for the linked Excel workbook before sharing.

共享仪表板对话框

  1. 输入同事的电子邮件地址。Enter the email addresses for your colleagues.
  2. 若要让你的同事能够从 Power BI 查看 Excel 工作簿,请选择转到 OneDrive for Business 以设置工作簿权限To enable your colleagues to view the Excel workbook from Power BI, select Go to OneDrive for Business to set workbook permissions.
  3. 在 OneDrive 上,根据需要修改权限On OneDrive, modify the permissions as needed.
  4. 选择共享Select Share.

备注

同事将无法固定此工作簿中的其他磁贴,并且不能在 Power BI 中更改 Excel 工作簿。Your colleagues won't be able to pin additional tiles from that workbook, or make changes to the Excel workbook from Power BI.

创建组织内容包(其中仪表板包含工作簿磁贴)Create an organizational content pack with a dashboard that contains workbook tiles

发布内容包时,对单个或成组的同事授予访问权限。When you publish a content pack you give access to individual colleagues or groups. 发布包含工作簿链接的内容包时,可以在发布前视情况修改链接的 Excel 工作簿的权限。When you publish a content pack that contains workbook links, you'll have the option to modify the permissions for the linked Excel workbook before publishing.

  1. 创建内容包屏幕中,输入电子邮件地址、为内容包提供标题和说明,并上传图像。In the Create content pack screen, enter email addresses, give the content pack a title and description, and upload an image.
  2. 选择链接到 OneDrive for Business 上的 Excel 工作簿的仪表板和/或报表。Select the dashboard and/or report that is linked to the Excel workbook on OneDrive for Business.

    内容包中的 Excel 工作簿

  3. 选择转到 OneDrive for Business 以设置工作簿权限Select Go to OneDrive for Business to set workbook permissions.
  4. 在 OneDrive 上,根据需要修改权限On OneDrive, modify the permissions as needed.
  5. 选择发布Select Publish.

从 Power BI 工作区共享仪表板Share a dashboard from a Power BI workspace

从 Power BI 工作区共享仪表板类似于从自己的工作区中共享仪表板,只不过文件位于 Office 365 工作区站点中而不是专用的 OneDrive for Business 中。Sharing a dashboard from a Power BI workspace is similar to sharing a dashboard from your own workspace, except that the files are located in an Office 365 workspace site, instead of your private OneDrive for Business. 与工作区外人员共享仪表板之前修改 Excel 工作簿的权限。Modify the permissions for the Excel workbook before sharing the dashboard with people outside the workspace.

从 OneDrive 共享

后续步骤Next steps