I have azure sql db that has AAD setup with MFA. So we do not have any username or password setup for it.
Now I have created an azure analysis server in the same subscription and I want to add this azure db as a source. I can choose Microsoft Account and sign in with my id. But I want to set Impersonation mode so no user details are used to access source db. Can Impersonation service account help me?
I have tried below steps-
Created a app registration in AAD. And added that as an admin on AAS. Also I added this service principal as a user in azure sql database and added it to owner role.