Forum Discussion
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:
- Go to File -> Options and Settings -> Options
- Options -> Security
- Check if your certificates have been revoked
- Tried Comprehensive Check
- Tried Basic Check
- Tried None
- Authentication Browser
- Tried Checking “Use Default web browser.”
- Try changing my default brower to:
- Chrome
- IE.
- 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.
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.
1 Reply
- v-jingzhangCommunity Support
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.