Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
89 | |
73 | |
69 | |
65 | |
57 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |