This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 32 | |
| 26 | |
| 23 | |
| 20 | |
| 20 |