George Woods

Customer Engineer - Global Technical Team at Microsoft



Overview of Connecting to Azure Analysis Services

19 Jul 2018

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