PowerQuery from Exchange reports invalid credentials
When I try to connect to Microsoft Exchange as a Query data source, it tells me that my credentials are invalid, when in fact they are not. I have also double and triple-checked that my account is not locked out or otherwise disabled, and my emails are coming
to Outlook just fine.
Any pointers or tips to helping me trace down what's blocking me would be greatly appreciated.
PS. I think this worked in the previous version of PowerQuery, but I don't know where to find that download now. I'd use it instead of anyone can tell me where to get it.
February 19th, 2014 3:30pm
Thanks for reporting this issue. We're following up via Frown so I'm marking this thread as complete here.
Marked as answer by
Miguel.LlopisMicrosoft employee, Owner
Wednesday, February 19, 2014 6:49 PM
February 19th, 2014 6:49pm
Thanks so much for your responsiveness, I never would have expected same-day (or in this case, same-hour) response!
February 19th, 2014 7:19pm
running into the same issue, could you please post how you managed to solve this?
March 6th, 2014 2:18pm
We are still investigating the original issue, if you are reporting a new issue, please report it via "send a frown" feature in Power Query to
pqfb@Microsoft.com so we can follow up with more debugging.
March 7th, 2014 7:34am
It's several months later, is there any update on this issue? We are experiencing the same issue with 2007 Exchange all patched up.
July 24th, 2014 12:43pm
Same here, and I sent that frown ages ago. Could we just dispense with autodiscovery? I know what I have to fill out, and the magic under the hood is quite obviously not working.
November 3rd, 2014 5:42pm
Which version are you on? I haven't had any issues since my reply above, I'm also using Excel 2013 now.
November 3rd, 2014 5:44pm
I had the same issue and I submitted a frown. Immediately after that I started playing with Outlook configurations and somehow it worked. Go to Outlook Account Settings, Change, More Settings > tab Connection. Try using Negotiate instead of NTML.
December 3rd, 2014 7:12am
Hi there, has been a while but do you recall how you overcame this issue in more detail?
August 22nd, 2015 2:20am
Have addressed this with you on the Power Bi Blog and Exchange connector issues.
This is connected with the queries on this thread which appears unresolved.
I have no doubt there is a simple fix for this
August 22nd, 2015 2:21am