Forum Discussion
Problem connecting to HTTPS web data via basic auth
In Power BI Desktop, I am trying to get web data via an HTTPS REST API using basic authentication. I enter the username/password in the data source settings but I consistently get this error message:
We encountered an error while trying to connect.
Details: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."
I've tried clearing the permissions in the Data Source Settings, but that did not help.
The REST URL works fine in Postman. Any suggestions?
4 Replies
mscherotter When you test, are you using http or https?
https
mscherotter , Check this topic in the past, very old and not marked as a solution. But few approaches have been discussed there -https://community.powerbi.com/t5/Power-Query/How-to-Authenticate-to-a-REST-API-with-basic-Authentication-in/td-p/105202
hi mscherotter
Clear the Secure Sockets Layer (SSL) state. To do this, follow these steps:
- In Internet Explorer, click Tools, and then click Internet Options.
- Click the Content tab, and then click Clear SSL state.
Regards,
Lin
