Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mscherotter
Employee
Employee

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 4
v-lili6-msft
Community Support
Community Support

hi @mscherotter 

Clear the Secure Sockets Layer (SSL) state. To do this, follow these steps:

  1. In Internet Explorer, click Tools, and then click Internet Options.
  2. Click the Content tab, and then click Clear SSL state.

 

Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super User

@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...

Greg_Deckler
Super User
Super User

@mscherotter When you test, are you using http or https?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

https

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.