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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
rborges
New Member

Self-Signed Certificates on PowerBI

I have seen this posted in some other topics, but so far, didn't find any sort of awnser.

Here's my deal: i'm feeding the data via HTTPS and using a self-signed certificate.. in a regular web browser, you can just ignore the alerts and proceed with it, but in Power BI it completely stops the imports.

 

"Could not establish trust relationship for the SSL/TLS secure channel." - this is the error it gives me back.

 

My question is .. is there any sort of way we can "ignore" this specific alert and use a self-signed certificate to be able to test our data source properly?

 

Until this moment, I have not found this information.

 

Any help or guidance via links that can help will be much appreciated.

4 REPLIES 4
tr123
New Member

I managed to get self signed certificates working with the method below. It only works with the downloaded Desktop version not the Windows Store app. You can't modify files in a Windows Store app.

 

Update the file C:\Program Files\Microsoft Power BI Desktop\bin\Microsoft.Mashup.Container.NetFX45.exe.config to:

 

<configuration>
  <system.net>
    <settings>
      <servicePointManager
        checkCertificateName="false"
        checkCertificateRevocationList="false"         
      />
    </settings>
  </system.net>
</configuration>

Restart Power BI.

I've been looking for this solution for a long time. Thanks! No solution was found for a Windows Store app?

Greg_Deckler
Super User
Super User

Use http instead?


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

If HTTP was a valid option for what I pretend to do , I would. In this case it is not, the information is sensitive.

 

Anyway, so far, if you install a domain certificate you need to add that certificate's supplier onto your certificate store.

 

That means the computer where you are running Power BI must trust a certificate supplied by A.

So in that computer, you add "A's Certificate" to your local machine certificate store.

 

This way you can at least test your project.

 

But anyway, it still seems to be too much of an extensive workaround when so many browsers already surpass this issue other than the warning.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors