Connect to Exchange (Power Query) Error

%3CLINGO-SUB%20id%3D%22lingo-sub-226752%22%20slang%3D%22en-US%22%3EConnect%20to%20Exchange%20(Power%20Query)%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-226752%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20following%20these%20steps%20to%20connect%20excel%20to%20Microsoft%20Exchange%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EClick%20the%20Data%20tab%2C%20then%20Get%20Data%20%26gt%3B%20From%20Other%20Sources%20%26gt%3B%20From%20Microsoft%20Exchange.%20If%20you%20don't%20see%20the%20Get%20Data%20button%2C%20the%20click%20New%20Query%20%26gt%3B%20From%20Other%20Sources%20%26gt%3B%20From%20Microsoft%20Exchange%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Access%20an%20Exchange%20Server%20dialog%20box%2C%20specify%20your%20Email%20Address%20and%20Password.%3C%2FP%3E%3CP%3EClick%20Save.%3C%2FP%3E%3CP%3EIn%20the%20Microsoft%20Exchange%20Autodiscover%20Service%20dialog%20box%2C%20select%20Allow%20to%20allow%20the%20Exchange%20Service%20to%20trust%20your%20credentials.%3C%2FP%3E%3CP%3EI%20accidentally%20clicked%20whatever%20the%20option%20is%20for%20%22Don't%20Allow%22%20is%20and%20now%20I%20get%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Unable%20to%20connect%22%3C%2FP%3E%3CP%3E%22We%20encountered%20an%20error%20while%20trying%20to%20connect%22%3C%2FP%3E%3CP%3E%22Details%3A%20%22EvaluateExchangeRedirectUnpermitted%20failure%3A%20the%20query%20'%3CA%20href%3D%22https%3A%2F%2Fautodiscover-s.outlook.com%2Fautodiscover%2Fautodiscover.xml%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fautodiscover-s.outlook.com%2Fautodiscover%2Fautodiscover.xml%3C%2FA%3E'%20isn't%20approved%20for%20execution.%22%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20right%20this%20wrong%20so%20I%20can%20connect%20to%20Exchange!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-226752%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hello,

 

I was following these steps to connect excel to Microsoft Exchange:

 

Click the Data tab, then Get Data > From Other Sources > From Microsoft Exchange. If you don't see the Get Data button, the click New Query > From Other Sources > From Microsoft Exchange

 

In the Access an Exchange Server dialog box, specify your Email Address and Password.

Click Save.

In the Microsoft Exchange Autodiscover Service dialog box, select Allow to allow the Exchange Service to trust your credentials.

I accidentally clicked whatever the option is for "Don't Allow" is and now I get this

 

"Unable to connect"

"We encountered an error while trying to connect"

"Details: "EvaluateExchangeRedirectUnpermitted failure: the query 'https://autodiscover-s.outlook.com/autodiscover/autodiscover.xml' isn't approved for execution.""

 

How can I right this wrong so I can connect to Exchange!

 

Thanks!

0 Replies