Skip to main content

Power BI

New

Client certificate authentication option in Power Query

Vote (48) Share
Scott Palmateer's profile image

Scott Palmateer on 28 Aug 2015 01:55:50

Power Query needs to add client certificates as an authentication option so that Excel can use them to authenticate to PKI-protected OData endpoints.

Comments (6)
Scott Palmateer's profile image Profile Picture

5385ea03 a4f9-4938-a4f4-c6dd8101726a on 06 Jul 2020 00:08:18

RE: Client certificate authentication option in Power Query

This seems like a significant gap and would be very useful to be able to authenticate from PowerBI this way and reuse our existing REST API

Scott Palmateer's profile image Profile Picture

08e573ab 6a54-4281-b0da-210ccea6e311 on 05 Jul 2020 23:35:38

RE: Client certificate authentication option in Power Query

This shouldn't be difficult to implement and, in my particular case, it's causing I need to look into other tools like Spotfire or Tableau...

Scott Palmateer's profile image Profile Picture

126e87df d28f-4c3d-ad7a-dc357a8e6be6 on 05 Jul 2020 23:30:39

RE: Client certificate authentication option in Power Query

Tableau has it... make it happen :)

Scott Palmateer's profile image Profile Picture

497e9089 f6aa-464d-b14a-0a75eec65f0c on 05 Jul 2020 23:17:56

RE: Client certificate authentication option in Power Query

When PowerBI already supports 5 authentication methods for odata feeds - how hard is it for the developers to add one more? :) The powerBI team seem to thrive on healthy competition - Does anyone else know of a similar tool that does allow certificate authentication to an odata service?

Scott Palmateer's profile image Profile Picture

94d922ef 0048-4415-a3a8-fa9c16a47d0d on 05 Jul 2020 23:06:46

RE: Client certificate authentication option in Power Query

Looks like this is still an open item and it's one of the disadvantageous to use either Power Query / Power BI

Scott Palmateer's profile image Profile Picture

40904973 eae5-4c7e-941c-5f442257c4f0 on 05 Jul 2020 22:28:34

RE: Client certificate authentication option in Power Query

HTTPS with client cert auth would be extremely helpful