Forum Discussion
We Couldn't Authenticate With The Credential Provided
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
Hi zctpklo ,
First you should distinguish the difference between an Exchange account and a Microsoft account, refer:
- Difference between Microsoft accounts
- 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).
