Forum Discussion
Excel Reporting : Can't connect to calendars with OData anymore (v2)
Hello everyone,
Some of you may remember my previous thread about the same-ish issue (https://techcommunity.microsoft.com/t5/project/excel-reporting-can-t-connect-to-calendars-with-odata-anymore/m-p/4132119) that ended up being solved by a Project Online patch.
But somehow, the issue returned. Not the same cause, since it has nothing to do with authentication this time, but the same symptoms : trying to fetch Calendar Exceptions data from an Excel OData query doesn't work anymore.
When trying to get the data, I am getting "Error 400 : Cannot get a CSOM-compatible PJContext for an HTTP request that started outside of CSOM."
It seems the issue started this morning on my client's tenant.
Has anyone else experienced the same issue ?
I just tried again this morning, and it appears to miraculously work! Who knows how/why it was fixed and/or when they will break it again...
8 Replies
Romain_Brunel - I'm getting the same error when retrieving calendar data from Power Query in Excel, but the same query works in the Power BI service.
Do you have any contacts to try to get this fixed again?
No, I opened a ticket with Microsoft and they fixed it. Can you pull the calendar data if you use Power BI Desktop?
