Forum Discussion

atpbi10's avatar
atpbi10
Icon for Helper I rankHelper I
5 years ago

Self signed cerificate API powerbi power query

Hey I'm trying to retrieve the data from API which is hosted on azure VM with self signed certificate, using this code:   let url = "https://***WEBSITEURL***/api/", source_url = "***WEBSITEURL***/...
Need Help
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi atpbi10 ,

Sorry for replying late. You can try this:

 

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.

 

You can also refer these articles:

  1. Could not establish trust relationship for the SSL/TLS Secure Channel – Invoke-WebRequest 
  2. Power Query Sign in, Certificates and Troubleshooting 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

atpbi10's avatar
atpbi10
Icon for Helper I rankHelper I
5 years ago

This did not work. Do you think maybe that changing https configuration on Azure VM on which the api is deployed on might help?

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi atpbi10 ,

    Perhaps you could take a try and check it.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.