Connecting to XMLA endpoint from a web app

Hi all,

I need to connect to the XMLA endpoint from a web application.

Normally if you call AdomdConnection.Open() from a client app then a UI is shown to allow the user to log in. Obviously this won't work for a web app.

I thought I might be able to register an App on Azure and grant it delegated read permissions for the users model/data, but

there doesn't seem to be such a permission available.

My plan was to to have the user log in, and once redirected to me I could add:

   "Password=" + securityToken

to the connection string.

I suspect I'm going about this the wrong way, how can I connect to the XMLA endpoint without the AdomdClient trying to pop up a UI on the server?

Thanks

Colin

P.S. this needs to allow MFA, so sadly I can't just put the email/password in the connection string.