Unable to open a mailbox with Exchange.Contents

[AMonitorInTime]

Hi, I have a very simple function

= (Account as text) as table=>

let
    Source = Exchange.Contents(""&Account&""),
    Calendar1 = Source{[Name="Calendar"]}[Data]
in
    Calendar1

That accepts data from a table of email addresses.

user1@domain.com

user2@domain.com

user3@domain.com

I then add a column and invoke the custom function, this all works fine for my email address and a shared mailbox address, but when I try to add someone else's email address I get the error

DataSource.Error: ErrorItemNotFound: The specified object was not found in the store., The process failed to get the correct properties.
Details:
    DataSourceKind=Exchange
    DataSourcePath=User3@domain.com
    Details=

The User3 email is not a shared mailbox, but someone else's. It can be viewed within outlook by adding it as a custom calendar, so I am unsure why I cannot query it using Power Query.

[v-jingzhang · Accepted solution]

Hi @AMonitorInTime 

I hope this blog will be helpful: https://community.powerbi.com/t5/Community-Blog/Connecting-to-Shared-Calendar-in-Power-BI-Desktop-am... 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

You can only query your own Outlook email. Can you imagine what IT do if you could muck around in someone else's email?!

--Nate

[AMonitorInTime]

Hi Nate, this would be nothing more than me going into outlook and manually adding someone's calendar.

Which is something you can currently do as long as their calendar has the permissions set to allow that.

I am not trying to edit calendars only view them in bulk, rather than having to do manual approach mentioned above.