Power Pivot can't connect to email Exchange (although Power BI can)

[binhtrinh]

In power pivot, I can't connect to Exchange email with the error below. Although it's Ok in Power BI. Anyone can help ?

DataSource.Error: ErrorNonExistentMailbox: The SMTP address has no mailbox associated with it.
Details:
DataSourceKind=Exchange
DataSourcePath=email adress
Details=

Power PivotPower BI

[Jimmy801]

Hello @binhtrinh 

I ran into the issue some time ago, and what I did is to hardcode the mail-account in the Exchange.Contents-function. Give it a try

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy