Exchange Problem

[Anonymous]

Hello,

I am trying to connect to an email through Microsoft exchange. I have used this connection for various emails and everything had been working fine. When I load the querry, i get the below error message.

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

[Anonymous]

I still havent figured out what is the problem and possible solution, but the error has changed. Now I get the below. The email does exist.

DataSource.Error: ErrorNonExistentMailbox: Mailbox does not exist.
Details:
DataSourceKind=Exchange
DataSourcePath=email@email.email
Details=

[v-juanli-msft]

Hi @Anonymous

Could you look into this link to see if it helps?

https://community.powerbi.com/t5/Issues/Error-when-trying-to-import-Exchange-Calendar/idi-p/185293

Best Regards

Maggie

[Anonymous]

Hello,

I tried clearing permision before, didnt solve the problem.

Thank you.

[v-juanli-msft]

Hi @Anonymous

Which kind of email box does yours?

Is it a shared mailbox?

I make a test as below and it works successfully.

In Power BI Desktop, connect to MS Exchange Online,

enter my email address (which is a outlook email, alos this account is used for Power BI Account)

select "Microsfot Account", sign in with my current account.

Finally, i can select which to connect to including "emails", "calendar", ect.

For the error message, "The specified object was not found in the store".

Follow these steps to troubleshoot the error:

• Verify the permissions for the migration admin account
• Verify the mailbox is not hidden from the Global Address List
• Verify the mailbox does not contain a folder name with a backslash (\) character

When check the permission, in Power BI, To use a new information to sign in, Clear permissions in data source settings and try again.

Best Regards

Maggie

[Anonymous]

Hello Maggie,

Yes it is a shared mailbox. In fact there are 3 other shared mail boxes which I have to use in the report. I can connect to them, but for this 1 specific I cant. Also when I add it to my outlook it is working fine. 

I tried to reset the permissions, but it didnt work.

[v-juanli-msft]

Hi @Anonymous

what is differece among three mail boxes, what is the specific?

Does these three mail boxes use the account which is also your Power BI account?

From threads below, it is noted that, when connect to shared mailboxes, you need enter the shared mailbox as the mailbox parameter, then use your own UPN(user name) & password.

https://social.technet.microsoft.com/Forums/en-US/182c1c88-15fc-4778-a3c4-049b479f826a/power-query-from-microsoft-exchange-folder-path-that-i-want-not-showing-up?forum=powerquery

https://community.powerbi.com/t5/Integrations-with-Files-and/Shared-mailbox/td-p/419592

Best Regards

maggie