cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

We Couldn't Authenticate With The Credential Provided

I know this is a question that has come up before, but I can't seem to get anything to work at the moment. I am just trying to connect to my outlook account with power query, and I keep getting this popping up when it's about to complete:
https://gyazo.com/92e9ec5f120f73cafdd1b43e952086a6

 

I am already signed in on Outlook with the same pw, so I know that it's not just a case of that. Any help would be greatly appreciated.

1 ACCEPTED SOLUTION

Hi @zctpklo 

You'll need a subscription that already includes Exchange, which is one of the Business plans. The Home plans don't include Exchange.

You can see what is provided in each subscription here https://www.microsoft.com/en-us/microsoft-365/business/compare-all-microsoft-365-business-products

If you have a Business subscription then you should be able to use the Exchange connector in PQ to connect to your mailbox.

Phil

View solution in original post

12 REPLIES 12
Community Support
Community Support

Hi @zctpklo ,

First you should distinguish the difference between an Exchange account and a Microsoft account, refer:

  1. Difference between Microsoft accounts 
  2. The Difference Between A Microsoft Account And An Office 365 Account 

If you cannot connect to microsoft exchange using microsoft account authentication, you can try to use the exchange account authentication. Please notice: To connect with Exchange account, please enter UPN even though it is shown as optional on account dialog box.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Hi. I was just using a regular microsoft outlook account. I used the second option (I didn't try using the exchange account, because I don't believe that's what I have).

Hi @zctpklo 

If you have just a 'regular' outlook.com account then it isn't actually using Exchange and you won't be able to connect to that account with Power Query.

To get data from PQ with the Exchange connector you will need either an Office/Microsoft 365 subscription that includes Exchange as the email store, or an on-premise Exchange server.

Phil

Ah ok, I see.

 

So, I do have one account that does have an office 365 subscription. How would I go about setting up exchange as the "email store" (the email ending is currently @outlook.com). 

Hi @zctpklo 

You'll need a subscription that already includes Exchange, which is one of the Business plans. The Home plans don't include Exchange.

You can see what is provided in each subscription here https://www.microsoft.com/en-us/microsoft-365/business/compare-all-microsoft-365-business-products

If you have a Business subscription then you should be able to use the Exchange connector in PQ to connect to your mailbox.

Phil

View solution in original post

Just tested out what you said with a business trial and it worked!!! Thank you so much. I wouldn't have figured this out if it wasn't for you!

Hi @zctpklo 

No worries 🙂

Phil


If I answered your question please mark my post as the solution.

If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

Super User III
Super User III

Hi,

 

Do you actually have an Exchange account or are you just using Outlook.com?

 

Phil

Just using outlook.com

Advocate I
Advocate I

Can you share the image by attaching here.

 

Also what authentication you are using while trying to connect, it should be Microsoft Account.

 

Just a quick fix, try clearing the data sources and then try again

Just tried clearing the data sources, but it didn't work 😞

Problem 

 

Yeah I did use Microsoft Account.

 

What do you mean by clearing the data sources? I opened a blank workbook to make this query (would that still make a difference)?

Thanks (I will try anyway though).

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors