Forum Discussion

MetricMan's avatar
MetricMan
New Member
4 years ago
Solved

Issues using a Web Certificate to authenticate API Data Source

I want to connect Power BI Desktop to a secure web application using a security certificate.  I have installed my certificate on my machine.  I can access the web URL through my web browser and see the content I want.  When I run a power bi query against the same URL on the machine with my certificate installed.  I get a 500 internal server error.  I would get a 500 internal server error if I didn’t have the certificate on my web browser.

 

I have tried to modify the following 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>

 

I have tried to modify these settings in the Power BI Desktop to:

 

  1. Go to File -> Options and Settings -> Options
  2. Options -> Security
    1. Check if your certificates have been revoked
  1.       Tried Comprehensive Check
  2.       Tried Basic Check
  •       Tried None
    1. Authentication Browser
  1.       Tried Checking “Use Default web browser.”
        1. Try changing my default brower to:
          1. Chrome
          2. IE.
          3. Edge

 

So far, nothing I have tried has worked.  My web browser happily accepts my web certificate, but not the Power BI Desktop application on the same machine. I spend some time looking for an answer and I would think there got to be something simple I can do to make this go. I would welcome any helpful hints.

1 Reply