Error getting data from OData API that requires both password and certificate authentification

[Farout104]

Hello,

I need to access data from an SSL secured API that requires clients to be authentificated via username/pwd and certificate. I am able to fetch data using a web browser with no issue after installing the certificate provided to me and signing in.

However, when I try to import data from this API on Power BI I get the following error: 

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

I have tried doing the following with no success:

• Adding the certificate to the Trusted Root Certification Authorities of the server
• Disabling certificate revocation in Power BI
• Clearing SSL state in the default browser
• Adding the SchUseStrongCrypto key to the registry

Any idea how to resolve this issue?

Thank you.

[aegalan]

Hello? just wondering if you find any solution? thanks.

[Anonymous]

Hi @Farout104 ,

What's the version of TLS?  To my knowledge, support for transport layer security (TLS) 1.0 and 1.1 for Power BI will end in June 2020. You need to upgrade the TLS version of your Power BI application to TLS 1.2.

Refer to:

Upgrade the TLS version of your Power BI application to TLS 1.2 | Azure updates | Microsoft Azure

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Farout104]

Hello @Anonymous 

Thank you for your reponse.

This doesn't seem to be the source of the issue. To my knowledge, Power BI Desktop uses TLS 1.2 by default. I also checked on the server itself and it has TLS 1.2 enabled, and so does the API source.

Is there anything else I could check? 

Thank You