could not establish trust relationship for the ssl/tls secure channel with self signed certificates

[aakashgaikwad]

I am currently working on fetching results from the  API to Power BI. I have encountered an issue during the Power BI query building process and would appreciate your assistance.

I have followed these steps:
- Installed Power BI (single user) from the Microsoft App Store.
- Selected Get Data -> Blank Query -> Advanced Editor (pasted content from the attached file).
- Clicked Done, then Close & Apply.

At this point, I am receiving an error. I have attached the relevant content and error details for your reference.

I have already tried couple of solution 
- importing sx root certificate
- made local host file entry 
- disabled possible option on power BI  (screenshot below)

Thank you for your time and support

[v-xiaoyan-msft]

Hi  @aakashgaikwad ,

You can bypass the SSL/TLS certificate verification by creating an unverified SSL context.

Here is a step-by-step approach to do this:

1. Create an Unverified SSL Context:

   • You need to modify the SSL context to bypass the certificate verification. This can be done by creating an unverified SSL context in your script.

2. Implement the Following Code:

   • Add the following code to your script to create an unverified SSL context:

import ssl

# Function to create an unverified SSL context
def create_unverified_ssl_context():
    ssl._create_default_https_context = ssl._create_unverified_context

# Call the function to create an unverified SSL context
create_unverified_ssl_context()

print("Unverified SSL context has been created to bypass the SSL/TLS certificate verification.")

This code will create an unverified SSL context, allowing you to bypass the SSL/TLS certificate verification and establish a secure connection.

Best Regards,
Community Support Team _ Caitlyn