Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.