I have to extract data from Project Server 2016 for reporting and tried to use SSIS OData method to connect. Within the OData Data Source Editor, I am able to preview Issues, Tasks, Risk and a few others but for the Projects collection I would get this error. Has anyone come across this error and knows what this means? I have not been able to find too many articles of project server and this error.
This is my first time using SSIS OData to extract project data. In previous project version, I used SQL query to extract data direct from SPS_1_PWA_1_ProjectWorkspaces_1. Thank you in advance.
