Exchange account vs Microsoft account and gateway connection

[nanda1986]

Hi all,

I'm trying to connect my mailbox to Power BI and automatically update this data via a gateway. In the report are also other connections (Excel files and Odata). Everything works fine (I select the "Exchange account" option in Power BI desktop, because when I choose the Microsoft account it says "DataSource.Error: ErrorNonExistentMailbox: Mailbox does not exist.". But when I then try to add this connection to the gateway, it gives errors about the credentials. It says "Cannot be added to gateway" and "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.".

Does anyone knows how to solve this? The option "Allow user's cloud data sources to refresh through this gateway cluster" is already on.

[Anonymous · Accepted solution]

@nanda1986 

What is the domain of your emails address? Is it @Microsoft.com or something else?

I was able to connect to exchange successfully with following steps:

1. Get Data from MS Exchange Online,

2. Enter my email address

3. select "Microsoft Account", sign in with my current account " xxxxxx@Microsoft.com".

4. Then I can get "emails", "calendar", etc.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.