Forum Discussion
Excel Reporting : Can't connect to calendars with OData anymore
RodFromm Romain_Brunel otgerpeidro
I just tested it with PowerBI Desktop and still no luck. Also refreshing the report from a published dataset doesn't work but we kind of expected that
Which fix did they implement?
KMathijs That is strange. In our tenant, I can query the Calendar table from Power BI desktop or Excel, but I get the same credentials error refreshing a published dataset or dataflow.
- Mine now works as well! I did have to enter credentials, which used to be anonymous, but it worked after that! I guess that's not a bad thing to require credentials, anyway.
Thanks to RodFromm for their work! Appreciate it. - Same for me today, calendar exceptions are refreshing correctly after entering credentials once. Thank you RodFromm for your work with MS.
- I can also confirm that it suddenly started working for me again. No change had to be made, only re-enable the auto refresh
DanMarkoff on my side it's working again, no change from my part. Maybe you have another issue?
- Still broken. I was so hopeful it would be fixed eventually. Will it? How can I ask Microsoft directly?
- RodFromm - where would I open that ticket?
DanMarkoff, Romain_Brunel, KMathijs - I asked Microsoft the fixed will be applied to all tenants. They gave no ETA for rollout but said the fixed was applied to all users (tenants) that reported the issue. If this is critical for your business it might be worth opening a ticket with Microsoft.
- My OData queries in Excel still don't work. They keep asking for credentials. Should this work? It used to...
- Hello, Same as KMathijs, it still won't work on my end when trying to create a new OData connection to the Calendars table. Let's hope they roll it on all tenants soon.
