Project Online Report Refresh Error in Excel

Hi Guys

I have built a report using OData (just shows tasks), which refreshes ok in IE for project server admins, but not for Project Managers. We get this error;

"We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh: Query - Tasks"

Any ideas?

July 27th, 2015 11:54am

Hello,

If you are using the SharePoint permission mode (default mode) then the users will need to be in at least the Portfolio Viewers group or higher as they will need "Access Project Server Reporting Service" permission.

https://technet.microsoft.com/en-us/library/jj219510.aspx

If you are using the Project permission mode, the users will need to be in a security group that allows the "Access Project Server Reporting Service" permission.

Paul

Free Windows Admin Tool Kit Click here and download it now
July 27th, 2015 12:03pm

Thanks Paul
July 28th, 2015 3:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics