Overview of Connecting to Azure Analysis Services
With Azure Analysis Services Firewall off.
As admin account – Log in to Azure
Deploy model
**Connect with SQL Server Management Studio from laptop
**
With admin account – 3 options for connecting
Does not work
Does not work
Using MFA does work – screen pops up for password and then another for text message before gaining access. – we can see the model as well, since this account is an Analysis Services Admin
As my non-admin account same three options for connecting
Does not work
Works but am just typing password in
Works but connects just asking for password, not asking for mfa, however does not have access to any databases as they are not marked as an admin. They will need a role assigned
**Connect from Power BI
**
Using non-admin account
Using admin account – asks for password and MFA text
As admin create a read role in the model
Add non admin to read role
Try again to connect from Power BI using non admin account
Connection works with no MFA
