Forum Discussion

Farout104's avatar
Farout104
Regular Visitor
4 years ago

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

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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Farout104
      Regular Visitor

      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

  • aegalan's avatar
    aegalan
    Frequent Visitor

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