power query

%3CLINGO-SUB%20id%3D%22lingo-sub-1572697%22%20slang%3D%22en-US%22%3Epower%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572697%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%20please%20tell%20me%20how%20to%20solve%20my%20problem%3A%20I%20have%20power%20query%20in%20excel%20and%20power%20bi.%20Power%20query%20does%20not%20allow%20you%20to%20create%20a%20connection%20to%20ms%20exchange.%20This%20service%20is%20not%20available%20in%20the%20program%20window.%20In%20power%20bi%2C%20everything%20is%20there%20and%20works.%20My%20account%20in%20Excel%20is%20my%20personal%20365%2C%20and%20power%20bi%20is%20my%20work%20account.%3CBR%20%2F%3E%3CBR%20%2F%3EDataSource.Error%3A%20Exchange%3A%20%D0%9D%D0%B5%20%D1%83%D0%B4%D0%B0%D0%B5%D1%82%D1%81%D1%8F%20%D1%81%D0%B2%D1%8F%D0%B7%D0%B0%D1%82%D1%8C%D1%81%D1%8F%20%D1%81%D0%BE%20%D1%81%D0%BB%D1%83%D0%B6%D0%B1%D0%BE%D0%B9%20Microsoft%20Exchange%20Autodiscover.%20%D0%A3%D0%B1%D0%B5%D0%B4%D0%B8%D1%82%D0%B5%D1%81%D1%8C%20%D0%B2%20%D1%82%D0%BE%D0%BC%2C%20%D1%87%D1%82%D0%BE%20%D1%81%D0%BB%D1%83%D0%B6%D0%B1%D0%B0%20Autodiscover%20Service%20%D1%83%D1%81%D1%82%D0%B0%D0%BD%D0%BE%D0%B2%D0%BB%D0%B5%D0%BD%D0%B0%20%D0%B4%D0%BE%D0%BB%D0%B6%D0%BD%D1%8B%D0%BC%20%D0%BE%D0%B1%D1%80%D0%B0%D0%B7%D0%BE%D0%BC%2C%20%D0%B0%20%D1%83%D1%87%D0%B5%D1%82%D0%BD%D1%8B%D0%B5%20%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D0%B5%20%D0%B2%D0%B5%D1%80%D0%BD%D1%8B.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1572697%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1572707%22%20slang%3D%22en-US%22%3ERe%3A%20power%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572707%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F752463%22%20target%3D%22_blank%22%3E%40Kmaxim3%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAvailability%20of%20connector%20in%20Power%20Query%20in%20Office%20apps%20(Excel)%20depends%20on%20your%20subscription%20(SKU)%2C%20you%20may%20check%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhere-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhere-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EConsumer%20subscriptions%20have%20much%20less%20connectors%20compare%20to%20enterprise%20one.%3C%2FP%3E%0A%3CP%3EAll%20available%20connectors%20by%20application%20are%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-query%2Fconnectors%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-query%2Fconnectors%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Good day please tell me how to solve my problem: I have power query in excel and power bi. Power query does not allow you to create a connection to ms exchange. This service is not available in the program window. In power bi, everything is there and works. My account in Excel is my personal 365, and power bi is my work account.

DataSource.Error: Exchange: Не удается связаться со службой Microsoft Exchange Autodiscover. Убедитесь в том, что служба Autodiscover Service установлена должным образом, а учетные данные верны.

1 Reply
Highlighted

@Kmaxim3 

Availability of connector in Power Query in Office apps (Excel) depends on your subscription (SKU), you may check here https://support.microsoft.com/en-us/office/where-is-get-transform-power-query-e9332067-8e49-46fc-97f...

 

Consumer subscriptions have much less connectors compare to enterprise one.

All available connectors by application are here https://docs.microsoft.com/en-us/power-query/connectors/