Authentifcation with .p12 file at a SOAP API

[prantto]

Hi, I have a problem. We have a backend that only have a SOAP API. The Problem is the Authentification at this end point works with a .p12 file. I haven't figured out how I can send the certificate over power bi. The only solution I saw, is to create a middleware that caches the data where I can authenticate with an support power bi method. Is there any way how I can avoid building this middleware and send the Certificate over the webconnector?

Best Regards

[lbendlin]

Not even sure if a custom connector can help with that.

Authentication with a data source - Power Query | Microsoft Learn

Looks like the middleware approach is the most promising (if klutzy).