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.
