Excel get data from Exchange

Question

I found a article Import Outlook to Excel with Power Query and followed it.

When I got to the login method, I choose "Exchange account" but that failed. And now when I try to connect I don't get the option to choose login method.

[Some related information has been masked by community engineers to protect your privacy.]

I asked a colleague to try it with the "Microsoft account" option and that works. So I can confirm that we dont have the option to use exchange account.

I have tried to find a method to remove/change the login method so I could change it, but to no avail.

Answer 1

Hi Mats

I can't provide precise steps as I don't have a connection to Exchange nor the Power Query Exchange connector. However, the principal remains the same whatever the data Source you connect to - that requires an authentication method: Excel stores your initial choice (and credentials) so you don't have to authenticate each time you connect to the same Source or refresh your query

As I understand you initially chose "Exchange account" and would like to get the following dialgo box again to choose "Microsoft account"

• Within Excel: Go to Data (tab) > Get Data > Data Source Settings
• In the Global Permissions search for your Exchange server name/domain name (I suppose - that's where I can't be precise)
• Select that data Source and at the bottom of the dialog box > Clear Permissions > Delete

You should now get the above dialog box again...

Answer 2

Glad I could help Mats & Thanks for posting back

Nice end of day... :)

Answer 3

Thank you SO MUCH ! it worked as a charm.

Case closed!