Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Issues with pulling calendar data from MS Exchange

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]

Need Help

6 Replies

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      The issue keeps persisting. 

  • Goibs's avatar
    Goibs
    New Member
    3 years ago

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

    • artur3221's avatar
      artur3221
      New Member
      3 years ago

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

  • YannickM's avatar
    YannickM
    Frequent Visitor
    2 years ago

    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!