When creating custom reports in Excel (Power Query), getting error "could not create ssl/tls secure channel"

[adarshmadrecha]

🙋 Question:

1. How to solve error "could not create ssl/tls secure channel" when refreshing data

[adarshmadrecha]

Reason

Your MS office version old and does not support latest encryption standards.

Solution

Using Registry Editor, add below registry keys

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319]
"SchUseStrongCrypto"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319]
"SchUseStrongCrypto"=dword:00000001

Note:

1. Both the dword are 32 bit values.
2. The exact .NETFramework version can be different in your case. But it should start with 4. Example: 4.x.xxxx
3. This solution may not work with MS office 2013, Windows 7.

Technical Explanation

Ref: Mircosoft Support
The error is because Excel/PowerQuery in your case is using TLS1.0 and the Jamku API is only using TLS1.2.

Note: Latest version of Excel and Windows uses latest TLS1.2/TLS1.3. This error will only appear in older MS Office 2016 versions.