Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Client certificate authentication option in Power Query

    Vote (109) 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 (11)
    Scott Palmateer's profile image Profile Picture

    Andreu fil on 19 Apr 2024 12:03:39

    RE: Client certificate authentication option in Power Query

    Good information, thankssehackear.top

    Scott Palmateer's profile image Profile Picture

    Matthew Collis on 08 Feb 2024 16:43:11

    RE: Client certificate authentication option in Power Query

    I would also like to see this. We want to start using dataverse to consolidate data into one spot. Some of the data we need is exposed through web api with only certificate auth as an option. There may be a workaround with some sort of proxy, but this isnt elegant enough. Having a native way to do this would be preferred.

    Scott Palmateer's profile image Profile Picture

    Francesca Battaglia on 12 Oct 2022 14:03:38

    RE: Client certificate authentication option in Power Query

    Isn't there a solution to this problem yet?

    Scott Palmateer's profile image Profile Picture

    Ryan Dozier on 02 Dec 2021 19:11:17

    RE: Client certificate authentication option in Power Query

    This would be great, currently need a way to do this within the Power Query environment.

    Scott Palmateer's profile image Profile Picture

    Björn Rafreider on 29 Jul 2021 17:15:02

    RE: Client certificate authentication option in Power Query

    Not only helpful, this is a must! What else is the windows certificate store good for, if even MS Applications don't use it?

    Scott Palmateer's profile image Profile Picture

    AndyH 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

    Javi Gonzalez 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

    Jack Berry 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

    Dean Dettman 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

    Shiva 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