Issues with pulling calendar data from MS Exchange

[Anonymous]

hello, I'm struggling with one issue, maybe somebody could help.

I'm using Power Query to pull calendar data from a shared email account linked to my personal one. I'm pulling the data from MS Exchange.

Until end of Feb, everything has worked. But now - it pulls only some random of the calendar events. I don't see any error pattern.

I've contacted IT from my org and they said email accounts are set up correctly and something could be wrong on the PQ side.

In M I'm just using: 

Source = Exchange.Contents("shared email address"),

Calendar1 = Source{[Name= "Calendar"]}[Data]

[YannickM]

I'm having very similar issues; for instance, for a calendar of a room I want to see all meetings Today. I get 4 meetings in PowerBI, but if I open the shared calendar in Outlook or Exchange I see 5 meetings Today. I cannot see any sprecific similarities between the missing meetings so far (meetings missing on other days as well), it seems random to me. I tried to use the Exchange as well as the Exchange Online source connector, same result. At this point I cannot deliver a reliable dashboard.

Any advice is much appreciated!

[Goibs]

I've started having this issue as well, did you find a fix?

[artur3221]

hey, unfortunately not. But it works for other shared calendars

[Icey]

Hi @Anonymous ,

• Do all people have the same issue as yours?
• Do the events shown have something in common?
• Is the access same as previous?
• Can the latest version of Power BI Desktop work?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The issue keeps persisting. 

[Anonymous]

hi @Icey,

thanks for this hint but unfortunately:

• all people have the same issue
• Missing events do not exhibit any specific pattern
• The access is the same
• The latest Power BI Desktop didn't work, neither did Excel PowerQuery

In all those permutations the same events are missing. 

Is there maybe another route to pull data from MS Exchange?