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 (12)
RE: Client certificate authentication option in Power Query
Client certificates come for free with a properly implemented TLS stack. Lack of support for client certs looks like a bug rather than a missing feature.
RE: Client certificate authentication option in Power Query
I find it so hard to believe this has been up here for nearly 10 years (!!) and nothing is done. Especially with NIS2 coming up, this is a must.
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.
RE: Client certificate authentication option in Power Query
Isn't there a solution to this problem yet?
RE: Client certificate authentication option in Power Query
This would be great, currently need a way to do this within the Power Query environment.
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?
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
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...
RE: Client certificate authentication option in Power Query
Tableau has it... make it happen :)
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?