Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
hi @mscherotter
Clear the Secure Sockets Layer (SSL) state. To do this, follow these steps:
Regards,
Lin
@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-Authentica...
@mscherotter When you test, are you using http or https?
https
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |