根据SharePoint组权限将数据提取到Excel报告中 [英] Fetch data according to SharePoint group permissions into Excel reports

问题描述

我们在SharePoint权限模式下使用MS Project Server 2013。我们在BI站点中开发了一些使用Excel服务的EXCEL报告。当用户（有权访问BI站点）查看任何excel报告时，他可以查看所有信息（即项目，任务，
资源等），而不管他的sharepoint组如何。如何根据组权限将数据提取到Excel报告中？

We are using MS Project Server 2013 in SharePoint permission mode. We have developed some EXCEL reports in BI site which use Excel services. When user( who has access to BI site ) views any excel report, he can see all information ( i.e. projects, tasks, resources etc. ) irrespective of his sharepoint group . How to fetch data according to group permissions into Excel reports ?

推荐答案

Sunil，

Sunil,

   如果您针对报告数据库或ProjectData ODATA端点进行报告，则不会进行安全修整 - 即全部或全部体验。  

   If you are reporting against the Reporting Database or the ProjectData ODATA endpoint then there is no security trimming - i.e. its an all or nothing experience.  

有一个安全修整的数据源，它是ProjectServer端点。  对于项目，它是：

There is a datasource that is security trimmed and that is the ProjectServer endpoint.  For projects it is:

https：// server / sites / pwa / _api / ProjectServer / Projects

https://server/sites/pwa/_api/ProjectServer/Projects

如果将其添加到Excel中作为ODATA数据源，您应该获得一个安全修剪项目列表，然后您可以通过ProjectUid连接到其他数据源以修剪用户看到的对象数量。

If you add that into Excel as a ODATA datasource you should get a security trimmed list of projects that you could then join to other data sources by ProjectUid to trim the number of objects seen by the user.

干杯，

    James。

   James.

这篇关于根据SharePoint组权限将数据提取到Excel报告中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！