MicrosoftThat is correct gwruck you will need to either use the OLAP cube or direct T-SQL.
https://pwmather.wordpress.com/2025/09/11/project-online-project-server-subscription-edition/
Thanks Paul, but is anyone actually looking at this pathway of using Project Server Subscription Edition? I can't even find a way to purchase and it doesn't appear to be available in any partner program that I can find. There are many organisations that just need a solid portfolio scheduling tool and don't need to go to P6. I'm not feeling that any of the emerging alternatives like InEight Scheduler, Altus or PMO365 are really a step up from what we already have, more just a step sideways with some extra features that are not schedule related. The more I look at it, the downsides of moving to another tool that that really doesn't improve much on the existing tool (if at all) are starting to balance against the downside of having to host Project on-premise. I'd like to hear from anyone that is also coming to this conclusion.
Hi gwruck You are 100% correct. A lot of these partners tools have a bunch of additional stuff that we don’t need, and Microsoft has made it very difficult to find how to purchase and setup Project Server Subscription Edition. Seems like all the links related to Project Server on Microsoft’s website just redirect you to planner, which they need to change! I’ve been looking at options for PSSE and I know some organizations/people that can help. Check out:
https://www.thepmoroadmap.com/project-online-to-project-server-the-enterprise-continuity-path/
And
https://www.apps4rent.com/microsoft-project-server-hosting/
you can also fill out this contact form (I can’t put my email directly in this thread) if you want to connect with me. I can share any additional info I know:
https://ssitools.com/contactsubmit/
I've spent some more time in PSSE now and can confirm that the OData feed (_api/ProjectData) is no longer available 😒. _api/ProectServer sems to still be supported though. Another surprising one I noticed was that Project Permission mode seems to have disappeared as well - I didn't notice that in the list of deprecations. I couldn't notice any other significant differences in the application.
It will be a bit more tricky to do any automation with Power Automate etc. I didn't test, but you will need to do direct rest calls to _api/ProjectServer endpoints - I didn't test how authentication would work though and suspect that will be a bit of a headache.
Administration of the tool will require someone who knows their way around Sharepoint administration, windows security, IIS, SSL certificates etc. Not for the feint-hearted. Querying either the Analysis Cube or backend database will require someone with mid-level SQL skills - although I can see a possibility that once this work was done and the data was in Power BI, "normal" odata consumers could get something similar to what they are used to.
If all you need is something that looks like the old Project Online and you are happy with Out of the Box features, this will probably fill a useful gap for you. However, if you want to do anything slightly different that previously relied on the reporting / automation layer, you are going to need to get creative. It's almost like they intentionally removed the good bits to make it harder for anyone to consider this as anything more than a stopgap to get past 30 Sept POL deadline.
You can turn on Project Server Permissions mode with Powershell. Let me know if you need more info, but is should be documented or just look for the command.
Thanks for your response KennyArnold_SSI . I'll probably keep all discussion in this forum so that others can benefit as well. I managed to install a 180 day trial of PSSE using the following link https://www.microsoft.com/en-us/download/details.aspx?id=103599&msockid=35aa2b79a8c0656337c03e82a92d647d. Unfortunately you will need to install it on Windows Server - it would not install on Windows professional. I was able to see the reporting tables from the db and configure a reporting cube. It is definitely a fair bit more involved than running up a new pwa instance in Project Online, but if you are persistent and follow the instructions, most technically-orientated people familiar with Server applications should be able to do it. The main issue I have now is how to buy it? MS talks about contacting a partner, but it would be great if we could just see pricing / buy online
