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:
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.
Solved! Go to Solution.
Hi @MetricMan
I am afraid currently Power BI doesn't support web certificate to authenticate Web API data sources. There are some similar ideas about this requirement below. You can vote them up or create a new idea.
Microsoft Idea · Client certificate authentication option in Power Query
Microsoft Idea · Support TLS client cert based authentication
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @MetricMan
I am afraid currently Power BI doesn't support web certificate to authenticate Web API data sources. There are some similar ideas about this requirement below. You can vote them up or create a new idea.
Microsoft Idea · Client certificate authentication option in Power Query
Microsoft Idea · Support TLS client cert based authentication
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!