SOLVED

The request was aborted: Could not create SSL/TLS secure channel.

%3CLINGO-SUB%20id%3D%22lingo-sub-1536431%22%20slang%3D%22en-US%22%3EThe%20request%20was%20aborted%3A%20Could%20not%20create%20SSL%2FTLS%20secure%20channel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1536431%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20getting%20below%20error%20while%20getting%20data%20from%20web%20on%20excel%202016%20(professional%20plus).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EError%3A%20DataSource.Error%3A%20The%20request%20was%20aborted%3A%20Could%20not%20create%20SSL%2FTLS%20secure%20channel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteps%20Used%3A%20Data%20%26gt%3B%20Get%20%26amp%3B%20Transform%20%26gt%3B%20New%20Query%20%26gt%3B%20From%20Other%20Sources%20%26gt%3B%20From%20Web.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%20Its%20running%20on%20Windows%2010%20Enterprise.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1536431%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1536675%22%20slang%3D%22en-US%22%3ERe%3A%20The%20request%20was%20aborted%3A%20Could%20not%20create%20SSL%2FTLS%20secure%20channel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1536675%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735237%22%20target%3D%22_blank%22%3E%40Mushyb4%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20with%20proper%20credentials%2C%20same%20as%20you%20use%20in%20other%20apps%20(e.g%20browser)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1537520%22%20slang%3D%22en-US%22%3ERe%3A%20The%20request%20was%20aborted%3A%20Could%20not%20create%20SSL%2FTLS%20secure%20channel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537520%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20with%20the%20same%20credentials.%20Also%20I%20tried%20other%20websites%20but%20same%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1538113%22%20slang%3D%22en-US%22%3ERe%3A%20The%20request%20was%20aborted%3A%20Could%20not%20create%20SSL%2FTLS%20secure%20channel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1538113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735237%22%20target%3D%22_blank%22%3E%40Mushyb4%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20that%20could%20be%20something%20related%20to%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2Fdeprecating-tls-1-0-and-1-1-support-in-power-bi%2F%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EDeprecating%20TLS%201.0%20and%201.1%20support%20in%20Power%20BI%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, I am getting below error while getting data from web on excel 2016 (professional plus).

 

Error: DataSource.Error: The request was aborted: Could not create SSL/TLS secure channel.

 

Steps Used: Data > Get & Transform > New Query > From Other Sources > From Web.

 

Please help. Its running on Windows 10 Enterprise.

3 Replies

@Mushyb4 

That's with proper credentials, same as you use in other apps (e.g browser)?

@Sergei Baklan 

 

Yes with the same credentials. Also I tried other websites but same result.

Best Response confirmed by Mushyb4 (New Contributor)
Solution

@Mushyb4 

As variant that could be something related to Deprecating TLS 1.0 and 1.1 support in Power BI