SSAS Connection String: Anonymous Impersonation Level

[nmesmeric]

Hey Guys,

I have an SSAS cube on premise and I am trying to connect from Power BI via an on prem data gateway.

To allow anonymous users access to the SSAS cube I need to specify the below in the connection string:

"Impersonation Level=Anonymous"

How can I add this to the connection string, I can't see anywhere where i can modify the connection string to SSAS?

Thanks,

Felix

[v-yingjl]

Hi @nmesmeric ,

To setup SSAS anonymous authentication you need to complete 3 steps :

• Change SSAS server property "Security\RequireClientAuthentication" value to False.
• Edit your connection string and add following parameter: Impersonation Level=Anonymous;
• Create SSAS database role and grant necessary permission to cubes and dimensions. Add user "NT Authority\Anonymous Logon" as a member of this role.

After such setup any user should be able to access your SSAS database without authentication.

The connection string is built using the information you provide in the Connection Manager dialog box. You can also view and edit the connection string in Management Studio in the data source property page.

Refer this FAQ: How to setup SSAS anonymous authentication 

About connection string:

1. Data Source properties 
2. Connection string properties 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[nmesmeric]

Hey v-yingjl,

Thanks for your response.

I have followed all instructions, however I have ended up with the same issue.

When connecting to an on premise SSAS server from Power BI Cloud via a data gateway, I cannot see anywhere where I can specify an impersonation level in the connection string.

Do you know where I can specifiy this? "Impersonation Level=Anonymous;"

On the gateway the connection doesnt allow you to specify any aditional parameters, it only allows a server name and database name.

Thanks for your help,

Felix

[v-yingjl]

Hi @nmesmeric ,

Please refer this document: Set Data Source Properties (SSAS Multidimensional) 

After setting connection string, you need to map users in power bi service, refer this document: Map user names for Analysis Services data sources 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi there,

When connecting to SSAS via the Gateway it would need to have an account which has got admin rights to the SSAS Server.

Once that is done, as far as I am aware the impersonation would have to include a user account. You could map this user account via the gateway to a user account on your SSAS instance which would allow all users access.