Error requesting data from an API that returns HTTPS

[lucioFFRAN123]

I've been trying in several ways to introduce data from an API that is returned in HTTPS.

Tried with PowerQuery, disabling in security but nothing works. How can I disable Power BI SSL?

[PhilipTreacy]

Hi @lucioFFRAN123 

The SSL Certificate for that website is misconfigured.  If you try to access that link you posted in a browser you should get a warning like this

When I look at the site's SSL certificate, it looks like they have generated it themselves, rather than having it issued by a Trusted Root Authority thjat issues SSL certificates (like GlobalSign, VeriSign etc)

The certificate says it was issued by Wesa4Biz.  This is not good practice for a publicly available website and could mean the site is untrustworthy.  Why are they issuing the certificate to themselves?

When you check the SSL Cert Details and Certification Path it confirms that they have created the certificate themselves.

This type of self-signed certificate will not be trusted by browsers, and Power BI.  That's the source of your issue.

Compare the cert above to a valid, trusted certificate

You can see this certificate has been issued by GlobalSign which is a Trusted Root Authority for issuing SSL Certs.  Browsers and Power BI will trust this certificate and allow you to connect to the site.

Furthermore, if you try to connect to the wesa4Biz website using HTTP, you get this error,

That shouldn't happen.  It should either work over HTTP, or better still, redirtect you to the HTTPS (encrypted connection) website.

So to summarize, the site you are trying to connect to is using an SSL certificate that they created themselves.  This is suspicious on a publicly available website and will not be trusted by browsers, or Power BI, and your connection to it will be blocked.

The site needs to buy an SSL cert from a Trusted Root Authority and install that new cert on their website.

Regards

Phil

[PhilipTreacy]

Hi @lucioFFRAN123 

Power Query has no issues connecting to an API over HTTPS so I don't think that is the issue.  Perhaps the API requires some authentriation and that is causing your problems.

Can you please provide more detials on what API you are trying to access.  Where is the documentation for it?  The documentation will specify how to connect, what authentication is required etc.

Regards

Phil

[lucioFFRAN123]

Good night, Philip.

Follow the API link: https://redeml.wesa4biz.com:49408/WSVendaProdutos?datainicial=2021-10-01&datafinal=2021-10-05

The API returns a json and has no authentication. When I try to importá in Power BI, it gives reliability and SSL error.