Forum Discussion

Romain_Brunel's avatar
Romain_Brunel
Copper Contributor
May 06, 2024

Excel Reporting : Can't connect to calendars with OData anymore

Hello there,   A few days ago, some of the Excel reportings I'm maintaining for a client stopped working because they get an "access denied" error when accessing data. I'm using OData connections t...
Romain_Brunel's avatar
Romain_Brunel
Copper Contributor
May 06, 2024

Update: When I try to create a new OData feed connection, while it won't work with the URL https://xxx.sharepoint.com/sites/pwa/_api/projectserver/ it will work with https://xxx.sharepoint.com/sites/pwa/_api/ps_projectserver/.
Then, I can see my Calendar tables in Power Query, but still can't open it (with the same error). I can access other tables just fine (CustomFields, EnterpriseProjectTypes, Events, Projects...). Another table I cannot access is the Settings one, even with Admin credentials.

Edit : The weird thing is that if I try going straight to the https://ifptr.sharepoint.com/sites/pwa/_api/ps_projectserver/calendars('b6635b2e-e747-4771-a78b-24f7509629d0')/BaseCalendarExceptions URL in the same browser I use for PWA, it instantly works and shows me the list of exceptions, but accessing it through Excel is still impossible.

Resources