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
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
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.