Forum Discussion
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 to get relevant informations from both the data sources below :
https://ifptr.sharepoint.com/sites/pwa/_api/projectdata
https://xxx.sharepoint.com/sites/pwa/_api/projectserver/calendars('calendarid')
The first data source is the usual one to get all the projects-related data. This one seems to still work fine when using the Admin account (authenticated using the "Organizational account" authentication type).
The second one I used to get the calendar exception list from the Standard calendar. It worked fine too until a few days ago and now I can't access it anymore, even with the Admin credentials.
When I try to reconnect to the data source I meet a message that says "We can't authenticate you with the given credentials. Try again.".
Did the authentication method for calendar access changed these last days ? Has anyone encountered this issue ?
Thank you very much
28 Replies
- Same issue here, our PowerBI is down since 2 months
- I'm facing the same issue. Have you gotten any response from Microsoft?
otgerpeidro Not yet, but I am actively working with Micrsoft to resolve this issue.
- Has anyone figured anything out on this? I'm having the same issues...
- Hi DanMarkoff,
I don't think we can do anything on our end. The connection works when established directly in a browser but fails when asked through OData (or Excel web data source).
I'm mostly waiting to see RodFromm 's ticket results.Romain_Brunel - I'm actively working with Microsoft on this issue and will provide updates as
I'm actively working with Microsoft on this issue and will provide updates as I receive them.
- Having the same issue. Going straight to the endpoint works (as per Romain's update) but pulling the OData feed fails. I am a global admin so I know it's not actually permissions-related. Hopefully we can figure this one out soon.
Romain_Brunel We are experiencing the same error when connecting via dataflows, or Power BI desktop and I have opened a ticket with Microsoft. It tired the workaround you suggested, https://XXX.sharepoint.com/sites/PWA/_api/PS_ProjectServer/, but get the same error
- RodFromm Thanks for the info, that's somehow good to know that the issue isn't only on my client's side. Let's hope it's just an issue from the last update and would get resolved soon.
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.
