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

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *