Forum Discussion
Unable to open a mailbox with Exchange.Contents
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.
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
[email protected]
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.
I hope this blog will be helpful: https://community.powerbi.com/t5/Community-Blog/Connecting-to-Shared-Calendar-in-Power-BI-Desktop-amp-Creating/ba-p/1293346
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
3 Replies
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.
I hope this blog will be helpful: https://community.powerbi.com/t5/Community-Blog/Connecting-to-Shared-Calendar-in-Power-BI-Desktop-amp-Creating/ba-p/1293346
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
