Forum Discussion
Excel Reporting : Can't connect to calendars with OData anymore
otgerpeidro Not yet, but I am actively working with Micrsoft to resolve this issue.
RodFromm I'm facing the exact same issue while I'm a Global Admin. Have you got any response from Microsoft?
KMathijs Microsoft has duplicated the issue and it is isolated to Project Online PWA sites. They didn't provide and ETA, but they are actively working on a fix and will provide updates as the team makes progress, which I will share as I receive them.
KMathijs Romain_Brunel otgerpeidro - I got a reply from Microsoft to test the fix they implemented for this issue! I am now able to access the ProjectServer/Calendar table data using Power Query in Excel and Power BI desktop. It still does not work if queried from a dataflow. I replied to Microsoft with my findings, and they are working on getting the query working with dataflows. Can you try querying the Calendar table and report back your results, which I will pass onto Microsoft?