Alternative to ODATA using MS Project SE (Subscription Edition)

[AlexanderCS]

Hi all,

until last week we were using MS Project Server 2016 and visualizing the data from the PWA in Power BI via the ODATA Connector. Last weekend SharePoint and MS Project were upgraded to Subcription Edition (SE) on prem and now the ODATA interface is no longer usable.

Do you have any idea how to make the data from the MS Project Server Subscription Edition PWA usable?

Best

Alexaner

[#2 · Accepted solution]

Hello @AlexanderCS ,

As you have found, the OData Reporting service has been removed from the Project Server subscription edition - https://learn.microsoft.com/en-us/project/deprecated-removed-features-project-server-subscription-ed... 

As per the link above, to create reports, use T-SQL queries against the pjrep schema in the database. 

Paul