Fetch data according to SharePoint group permissions into Excel reports RRS feed

  • Question

  • 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 ?
    Wednesday, June 24, 2015 11:13 AM

All replies

  • Sunil,

       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.  

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


    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 Boman BSc. MCP:EAD -

    Tuesday, July 14, 2015 12:41 AM